Current location - Quotes Website - Signature design - How to disable macros in EXCEL tables
How to disable macros in EXCEL tables
First of all, you need to put the Office 2003 installation CD into the CD-ROM drive, re-run the Microsoft Office 2003 installation program, select the advanced customization check box of the selected application, then click Next to enter the advanced customization window, expand the tree directory of Office*** enjoyment functions in the update options list box of applications and tools, click the digital certificate option of VBA project, select the menu item run from this computer in the pop-up drop-down menu, and then click Update.

After the installation is completed, exit the installation program of Office 2003, return to my computer window, then click the search button to search for SelfCert.exe application, and then run the found SelfCert.exe application. At this point, the system will automatically pop up the dialog box for creating a digital certificate, then enter "wfy Macro Command" in your certificate name text box, and then click OK, and the system will automatically pop up the SelfCert success dialog box, indicating that the personal digital certificate has been successfully created.

Next, click the Tools Macro menu item to open the macro dialog box, then select the macro to be digitally signed in the macro name list box, then click the Edit button to enter the VBE window interface, click the Tools Digital Signature menu item to open the digital signature dialog box, click the Select button, then select the newly added personal digital certificate in the opened certificate selection dialog box, and then click the OK button to display the digital signature of this macro command in the digital signature dialog box. Click OK to create a successful digital signature for this macro command.