Skip to Content
0

How execute command in vba for analysis microsoft excel to protect, unprotect BPC 10.1 embedded

Jan 05, 2017 at 09:39 AM

464

avatar image
Former Member

Hi Expert,

I need to execute a command in vba for analysis for office to protect and unprotect a book. Does anybody know if it exists? (BPC embedded)

ActiveSheet.Protect -> but for Analysis protect.

Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Jan 05, 2017 at 09:43 AM
0

Please explain what are you using? Analysis tab or EPM tab?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 05, 2017 at 10:02 AM
0

Hi,

Analysis tab.

Thank you!

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 05, 2017 at 10:22 AM
0

As far as I know there is no special protection API for Analysis tab...

Share
10 |10000 characters needed characters left characters exceeded
Gerd Schoeffl
Jan 26, 2017 at 12:28 PM
0

Hi Ricardo,

In Analysis for Office 2.4 this feature is available in AO. Click 'File' in the menu of an AO workbook and go to 'Analysis'. You will find 'Protect Workbook' as last entry in the list of offered features.

Best regards, Gerd


Show 1 Share
10 |10000 characters needed characters left characters exceeded

The question was about VBA API, not about menu...

0
Gerd Schoeffl
Jan 26, 2017 at 01:03 PM
0

Well, this is true. But if you just use the normal workbook/sheet protection then AO cannot perform all actions changing locked cells anymore (e.g. hide totals). If you first lock the workbook with the AO locking described above you can un-lock and re-lock the workbook by VBA. I just tested it and in my case all AO features work. Thus the AO locking is a prerequisite. Best regards, Gerd

Show 1 Share
10 |10000 characters needed characters left characters exceeded

But without changing the password! When the workbook is locked by AO, the password is saved in the file and used to temporary unlock file for AO operations.

0
Gerd Schoeffl
Jan 26, 2017 at 02:32 PM
0

Yes - one has to use the same password. Interestingly I used a workbook for testing that was protected by AO (with password), then I used Excel functionality/VBA to un-protect (entering the pwd) and protected the sheet again WITHOUT password. Still the AO features did work fine. Nevertheles I would always use the pwd.

Best regards, Gerd

Show 1 Share
10 |10000 characters needed characters left characters exceeded

"protected the sheet again WITHOUT password. Still the AO features did work fine."

If the sheet is protected without password then unprotect function will work even with some password :)

But after AO will protect the sheet back after finishing update the old password will be restored.

I have spend some time in the past to find the place where the password is stored for EPM Add-In (Not for AO), please read my blog: https://blogs.sap.com/2016/12/01/how-to-get-epm-protection-password/

The same can be done for AO...

0