Skip to Content

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

Apr 12, 2017 at 02:04 AM


avatar image
Former Member

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