Skip to Content
0
Jan 18, 2018 at 09:30 AM

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

190 Views

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