Use the certificate in Excel

[mdazizulh316]

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.