SetSheetOption , Custom Expand

[Former Member]

Hello,

I need custom expand when my sheet is protect. When my sheet is protect , buttons expand/collapse is disabled.

I have several checks  in my sheet and use VBA/API EPM depending on option

option 1.- Children

EPMObj.SetSheetOption Sheet1, 0, 1

option 2.- Member and Children

EPMObj.SetSheetOption Sheet1, 0, 2

And I need option 3: Custom Expand ( Include Member, and Only Base Level) when I execute double click in a member. When you select Custom Expand, a dialog box opens and you can define the levels you want to display and if you want to include the selected member or not. For example: only level 4, the selected member and down to level 3, or Include Member and Only Base Level,  etc

Please, any help?

Regards

RTS

[former_member186338]

Unfortunately this option is not supported by EPM VBA API.

Vadim

[Former Member]

Thanks Vadim,

Any workaround? suggestions?

RTS

[former_member186338]

Very complicated way - to emulate the full process in VBA starting from double click event, member hierarchy parsing etc...

Vadim