Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Execute macro when opening Report in BPC 10.0

Hi all,

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.

Sub After_Workbook_Open()

Call grouping

End Sub

Sub grouping()

  With Worksheets("IS HEPS BEPS")

  .Unprotect "123"

  .EnableOutlining = True

  .Protect "123", contents:=True, userInterfaceOnly:=True

  End With

End Sub

If I execute the macro directly in Excel it works as expected.

Can you help me identifying what may be missing?

Best regards

João Arvanas

Not what you were looking for? View more on this topic or Ask a question