BPC nw Excel vba macro security
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 :
well, it doesn't work at all unless i changed once again the macro
security to "Enable all macros (not recommended..." : then, it works
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.
Vadim Kalinin 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.