Skip to Content
avatar image
Former Member

SAP BPC EPM SetSheetOption in VBA - Which codes to use?

Hi, I'm trying to set sheet options upon workbook open. I'd like to set "Keep Formulas static that refer to report cells" and "Perform refresh on expand/collapse of members." I found the SetSheetOption syntax, but I can't find a list of what code numbers to use for these options.

EPMobject.SetSheetOption ThisWorkbook.Worksheets("Sheet2"), 1, True

Instead of 1, which codes should I put in?

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 12, 2017 at 07:49 AM

    Why not to read EPM help???

    42.4.3.1 SetSheetOption

    Keep Formulas Static that Reference Report Cells 208

    The second option "Perform refresh on expand/collapse of members" is not documented but it's easy to propose that the code will be 209

    And the test shows that 209 is correct!

    Add comment
    10|10000 characters needed characters exceeded