Financial Management Blogs by SAP
Get financial management insights from blog posts by SAP experts. Find and share tips on how to increase efficiency, reduce risk, and optimize working capital.
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_sendzik
Employee
Employee
4,530

Hi,

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.)

For example:

Sub AFTER_REFRESH()

Application.ScreenUpdating = False
   
'Autoscroll to Area on Sheet
    Worksheets("PAC P&L Planning").Activate
    ActiveWindow.ScrollRow = Range("G30").End(xlUp).Row       
Application.ScreenUpdating = True
  
Range("G30").Select
  
End Sub

kind regards

Thomas

2 Comments