Customer created a workbook using the SAP Analysis for MS Office version 2010. The workbook has one EPM sheet (based on the EPM plugin) and 2 Analysis sheets (based on the Analysis plugin). Worksheet protection was implemented via the SetSheetOption api using the following VBA code:
api. SetSheetOption "sheet name",300, True, "password", 20592
All sheets get protected (EPM sheets and AO sheets).
When executing the following sheet protection removal code:
api. SetSheetOption "sheet name",300, False, "password"
The code does not remove the protection from the Analysis plugin based sheets and customer is unable to change workbook and data source level settings. EPM sheets do get unprotected.
- SAP Business Planning and Consolidation version for SAP NetWeaver
- SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver
EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , BI-RA-AO-BPC , BusinessProcessFlow, Workstatus and BPC for AO , EPM-BPC-NW , NetWeaver Version , Problem
About this pageThis 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.