on 05-31-2017 4:11 PM
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
For Epm functions enable events has to be true!
And the idea to refresh report on activate worksheet is not good in general.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.