SAP Knowledge Base Article - Preview

2506926 - Unexpected Protection Options are selected when using EPM API to protect worksheet


You are using the following VBA code to protect the worksheet

Dim api As Object

Set api = Application.COMAddIns("FPMXLClient.Connect").Object
Dim SheetProtectionOptions As Long
SheetProtectionOptions = FPMXLClient.ProtectSheet_ProtectContents + FPMXLClient.ProtectSheet_AllowFormatColumns + FPMXLClient.ProtectSheet_AllowUsingPivotTables
api.SetSheetOption Sheet2, 300, True, "mypassword", SheetProtectionOptions

You are only expecting "Format Columns" and "Use PivotTable Reports" are selected, but "Edit Objects" and "Edit Scenarios" are also selected.

Unexpected Protection Options.png



SAP EPM solutions, add-in for Microsoft Office


KBA , EPM-XLS , EPM Excel Client , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.