Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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


Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

The correct constant name is:


0 Kudos

Great, thanks Vadim.

Answers (0)