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. 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

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.

If you can open Excel with macors. Thengoto View-->Macros popup shows macro list then click EditVBA editor will open then goto menu Tools--> Digital SignatureCertificate name: SAP AG click Detail button.Details TAB click Copy to FileThen Import .cer file to Internet option --> Content TAB --> Publishers button --> ImportCheck again in Excel - Option - Trusted Center - Trusted Publishers

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 linkView Certificate buttonInstall Certificate buttonChoose the certificate place in current user under trusted publishers than okthan 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.

Problem Enable Macros on Excel | Microsoft Community Hub

kelsyeong
Copper Contributor
Aug 30, 2022
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.
- Natanael90
  Copper Contributor
  Sep 05, 2022
  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.
  - kelsyeong
    Copper Contributor
    Sep 05, 2022
    Natanael90
    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)
- SuperUser19
  Copper Contributor
  Oct 20, 2022
  It worked for me. Thank you so much for this work around!
nad60
Copper Contributor
Nov 03, 2022
Natanael90 Hi, I’m facing exactly the same issue. Have you found the solution yet?
Carlos Mendão
Copper Contributor
Nov 14, 2022
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.
- Denise Child
  Iron Contributor
  Dec 05, 2022
  We have the same problem, no digital signature when we open macros.
  We have SAP 7.20 patch 5. This started after Microsoft updated a certificate in Excel on 8/3/2022 for Microsoft Windows Defender Advanced Threat Protection.
  The only workaround is to open any Excel file in OneDrive before we export to Excel. We use AVD.

Forum Discussion

Problem Enable Macros on Excel

Share

Resources