Problem Enable Macros on Excel

New Contributor

Hi Good days all,

 

We had some trouble regarding with enabling macros option on specific user.

Our issue regarding with "enable button" on Security Notice.

 

Screenshot_3.jpgScreenshot_4.jpg

Our SAP Application generating / exporting Excel report with macro, and majority of our user capable to enable the macro to access the Excel files.

 

How to enable the macro button on excel application. Even we already tried to reinstall the Office application but no luck. But in the same computer we tried with other user profile it's work. Is there anyway 

9 Replies

@Natanael90 we face the same issue, temporary solution will just need to open any excel file with data inside and leave it (dont close the excel) than continue generate report from SAP and it will work. 

 

from there you able to view the cert, you can choose to import and export than place in trusted publisher in excel later, so you can run the report without any excel open.

Thanks for your reply, but can you be more specific how to import / export the certificate ?

Since we already tried your method, opening the excel doesn't give amy response to view certificate and import/export.

@Natanael90 

Show Signature Details link

kelsyeong_0-1662367907586.png

View Certificate button

kelsyeong_1-1662367920847.png

Install Certificate button

kelsyeong_2-1662367933940.png

Choose the certificate place in current user under trusted publishers than ok

kelsyeong_3-1662367988284.png

than you are good to go without any excel open also can generate report from SAP now. (please make sure you have excel open with data, only you have the enable button visible and the show certificate link)

 

 

@kelsyeong 

Hi thanks for your response again,

 

How to enable the "Show Signature Detail" ? Seems our SAP doesn't produce any certificate while generating the report 

 

This is what i produce when tried to generate the report from capable computer. 

There is only Enable Button Macros without Signature details to export the certificate and put the certificate on problem computer.

Screenshot_27.jpg

 

 

 

 

It worked for me. Thank you so much for this work around!
I'm having the same problem but also with no "Signature Details" button. Any solution to this? SAP is a pretty huge necessity to a lot of organizations
@Natanael90 Hi, I’m facing exactly the same issue. Have you found the solution yet?
Hi,
We have the same problem, someone solve this?
Dont have button show siganture details to see certificate and add certificate to trusted publisher.
We have SAP 7.60 patch 13.
If you can open Excel with macors. Then
goto View-->Macros popup shows macro list then click Edit
VBA editor will open then goto menu Tools--> Digital Signature

Certificate name: SAP AG click Detail button.
Details TAB click Copy to File

Then Import .cer file to Internet option --> Content TAB --> Publishers button --> Import
Check again in Excel - Option - Trusted Center - Trusted Publishers