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