Execute macro when opening Report in BPC 10.0
I need to execute a macro to allow grouping and ungrouping some rows and columns, in a protected EPM Report.
I have developed the following routines, but they continue not to be executed when I open the report.
With Worksheets("IS HEPS BEPS")
.EnableOutlining = True
.Protect "123", contents:=True, userInterfaceOnly:=True
If I execute the macro directly in Excel it works as expected.
Can you help me identifying what may be missing?