Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC nw Excel vba macro security

Hi,

My environment : SAP BPC NW 7.5 SP17 / Excel 2013

We have recently changed the macro security for Excel from "Enable all

macros" to "Disable all macros with notification".

We can no more refresh the data from the report nor send input data to

the database : it seems like that the functions "MNU_ETOOLS_REFRESH"

and"MNU_ETOOLS_EXPANDANDREFRESH" cannot be executed (no effects at all).

I have tried to change the macro security option to "Disable all macros

except digitally signed macros" and the two buttons work correctly ie

we can refresh and send data again.

Also, I have found out something strange after some other tests : even if i

have defined the macro security to "Disable all macros except digitally

signed macros", only the buttons with the behind functions

"MNU_ETOOLS_REFRESH" or "MNU_ETOOLS_EXPANDANDREFRESH" work properly.

I meant that if i add another button with the following VBA code :

msgbox "hello"

well, it doesn't work at all unless i changed once again the macro

security to "Enable all macros (not recommended..." : then, it works

fine.

If we want an input schedule work properly with BPC internal functions ("MNU_ETOOLS_REFRESH"

and"MNU_ETOOLS_EXPANDANDREFRESH") and VBA code (button), is it mandatory to

define the macro security to "Enable all macros...." ?

Are there some other ways to workaround this issue ?

Thanks for your feedback.

Former Member
replied

I have already explained you everything, you have to test yourself!

1. You create self-signed certificate with some "Group" name like "Company XXX development"

2. Using standard Windows applet export this certificate without private key - xxx.cer file.

3. Distribute using AD this xxx.cer to trusted publishers to all users that will have to run macros signed by this certificate.

4. Extract this certificate with private key using jailbreak - resulting in xxx.pfx file

5. Import the certificate with private key to the persons who will create and sign macros in VBA.

Done.

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question