How to run a VBA after EPM AddIn
I had a problem in creating a VBA that is executed everytime a Layout is opened.
While trying the classical “WORKBOOK_OPEN” String I remarked that some of the actions were overwritten by EPM Add-In as the Layout was not ready loaded when the code was executed. The reason for that is, that EPM Add-In functionalities run after the “WORKBOOK_OPEN”.
Gladly a colleague gave me the right tipp:
Insert a SUB in a Module that contains the string “AFTER_REFRESH” instead of “WORKBOOK_OPEN” – and it works fine (thanks P.-J.)
Application.ScreenUpdating = False
‘Autoscroll to Area on Sheet
Worksheets(“PAC P&L Planning”).Activate
ActiveWindow.ScrollRow = Range(“G30”).End(xlUp).Row
Application.ScreenUpdating = True