Forum Discussion
Problem Enable Macros on Excel
Show Signature Details link
View Certificate button
Install Certificate button
Choose the certificate place in current user under trusted publishers than ok
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)
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.
 
- 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 PublishersWeFreeFly , thanks for the suggestion. I tried and got stuck when i opened Tools--> Digital Signature, there is [No certificate]. Any recomendation?
- same with me.
anyway, I tried import cert from www.sap.com because I can't find SAP AG cert.
still error.
- This worked for me with 7.40 and 7.60 and M365 excel.
Just few words additionally: in excel you may need to activate Developer Tab by customizing the ribbon and then go to VBA editor. SAP AG certificate should be imported into USER CERTIFICATES-TRUSTED PUBLISHERS.
