Current location - Quotes Website - Signature design - How to add digital signature to vba project in EXCEL
How to add digital signature to vba project in EXCEL
Select "microsoft office" in all programs and "microsoft office Tools" in the drop-down box on the right. Click "VBA Project Digital Certificate" to pop up the "Create Digital Certificate" dialog box, enter your certificate name [Y]: click "OK" to create a digital certificate.

Then open the EXCEL worksheet with a macro, press Alt+F 1 1, click Tools and select Digital Signature in the drop-down box, select the signed digital certificate, and click OK. Then close the EXCEL worksheet, open it again, and install the digital certificate according to the prompt. After installation, existing macros will not be prompted.