Hi Everyone,
I have one work book and have below code to refresh for all the sheets when sheet is active.
When I switch from EPMFormattingSheet to any sheets then i am getting below error Please see below SS.
-------------------------------------------
Private Sub Worksheet_Activate()
Application.EnableEvents = False
Dim epm As New FPMXLClient.EPMAddInAutomation
epm.RefreshActiveSheet
Application.EnableEvents = True
End Sub
-----------------------------------------
Can you please help me is there anything problem in my code?
Note: I cleared cache but i am still getting same error and,works fine if i dont have above code for all sheets.
Thanks,
Vishu
check sheet name in your code before refresh.
Hi vadim,
As you suggested i tried with below code but i am still getting same error.
Private Sub Worksheet_Activate()
If ActiveSheet.Name Like "EOP CO by Scenario" Then
Dim EPM As New FPMXLClient.EPMAddInAutomation
EPM.RefreshActiveSheet
End If
End Sub
For Epm functions enable events has to be true!
And the idea to refresh report on activate worksheet is not good in general.