Use the certificate in Excel
Posted: Sat Apr 05, 2025 6:13 am
Open Excel and go to the Developer Tools . If they're not visible, enable them in File > Options > Customize the Ribbon .
Click Visual Basic to open the VBA Editor.
In the Project Explorer, select the macro you want to sign.
Go to Tools > Digital Signature .
Click on “Select Certificate” and select the certificate you created previously.
Confirm with OK .
3. Save file and adjust macro security
Save the file as a macro-enabled workbook (.xlsm) .
Go to File > Options > Trust Center > Macro Settings .
Select the option “Enable only chinese overseas asia database digitally signed macros” .
Advantages of a self-signed certificate
No additional costs: No need for an official certification body.
Increased security: Macros can be recognized as trustworthy by Excel.
Easy implementation: Can be used quickly and easily for internal applications.
Self-signed certificates provide a simple solution for macro security in closed systems, but are not suitable for publicly distributed macros.
Click Visual Basic to open the VBA Editor.
In the Project Explorer, select the macro you want to sign.
Go to Tools > Digital Signature .
Click on “Select Certificate” and select the certificate you created previously.
Confirm with OK .
3. Save file and adjust macro security
Save the file as a macro-enabled workbook (.xlsm) .
Go to File > Options > Trust Center > Macro Settings .
Select the option “Enable only chinese overseas asia database digitally signed macros” .
Advantages of a self-signed certificate
No additional costs: No need for an official certification body.
Increased security: Macros can be recognized as trustworthy by Excel.
Easy implementation: Can be used quickly and easily for internal applications.
Self-signed certificates provide a simple solution for macro security in closed systems, but are not suitable for publicly distributed macros.