Forum Discussion

Natanael90's avatar
Natanael90
Copper Contributor
Aug 22, 2022

Problem Enable Macros on Excel

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 gener...
Excel
Natanael90's avatar
Natanael90
Copper Contributor

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.

 

 

 

 

 

WeFreeFly's avatar
WeFreeFly
Copper Contributor
Nov 25, 2022
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


  • nad60's avatar
    nad60
    Copper Contributor
    Jan 13, 2023

    WeFreeFly , thanks for the suggestion. I tried and got stuck when i opened Tools--> Digital Signature, there is [No certificate]. Any recomendation?

     

     

    • ferfer2130's avatar
      ferfer2130
      Copper Contributor
      Jan 17, 2023
      same with me.
      anyway, I tried import cert from www.sap.com because I can't find SAP AG cert.
      still error.
      • RicardoGTI's avatar
        RicardoGTI
        Copper Contributor
        Apr 14, 2023
        Hi, I already downloaded the certification, and I used in a arond 3 computers and it worked. Maybe works for you. I dont know if i cant post here the certification, but i can share you from my onedrive or something.
  • RobSkal's avatar
    RobSkal
    Copper Contributor
    Jan 17, 2023
    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.

Resources