SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

SAP EPM solutions, add-in for Microsoft Office

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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