Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 18 at 09:22 PM

    The correct constant name is:

    ProtectSheet_AllowGroupOutlining

    Add comment
    10|10000 characters needed characters exceeded