Skip to Content
0

SAP BPC EPM SP29 New Group/ Ungroup Feature for Worksheet Protection

Jan 18 at 09:30 AM

59

avatar image

Hi experts.

from SP29 of EPM it is finally possible to set up Group/ Ungroup for a protected worksheet wihin EPM SheetOptions.

For another reason i have to VBA unprotect my sheet and set up these Option again using VBA.

In the user Guide a lot of Options are explained but not the Group/ Ungroup Option.

I tried (as recommended with Standard Microsoft Code), but (surprise) it is not working:

Dim api As Object

Set api = Application.COMAddIns("FPMXLClient.Connect").Object

Dim SheetProtectionOptions As Long

SheetProtectionOptions = FPMXLClient.ProtectSheet_ProtectContents + FPMXLClient.ProtectSheet_UserInterfaceOnly + FPMXLClient.ProtectSheet_EnableOutlining

api.SetSheetOption Sheet1, 300, True, "mypassword", SheetProtectionOptions

I know i could use VBA to set up Standard Microsoft Protection, but i guess i should be possible to address the new Option within EPM.

Thanks for your help

Sebastian

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

1 Answer

Best Answer
Vadim Kalinin Jan 18 at 09:22 PM
0

The correct constant name is:

ProtectSheet_AllowGroupOutlining

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Great, thanks Vadim.

0