Skip to Content

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

Apr 12, 2017 at 02:04 AM


avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Apr 12, 2017 at 07:49 AM

Why not to read EPM help??? 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!

10 |10000 characters needed characters left characters exceeded