Enhance Office document security with macro digital signatures

Many experts like to use the "macro" command to improve office productivity. However, when you use macros in a Microsoft Office program, a macro security warning pops up, especially when you make a personal resume table, you often need to use a macro, and each time you open it, it makes the user feel more troublesome. If you set the security level of the macro to "low" to avoid the pop-up of security warnings, it increases the risk of malicious code and virus attacks. What do we do? As a matter of fact, just add a signature to your macro and you can do it once and for all. Let's take a look at Microsoft Excel, for example, to talk about the specific setup method.

Step one, set the macro security level to low

Open Excel, select tools → macros →visual Basic editor, select Insert → module in the Visual Basic editor, and enter three lines of code in the window: Sub Macrodm (), msbox "My Macro", end Sub (no punctuation after code). Then select file → Close and return to Microsoft Excel to save and close the current Excel file. Then open just the file, there is a security warning, prompted macros are disabled, then we need to select "tools → macro → security", in the pop-up dialog box, the "macro" security level set to "Low", and click "OK" to save.

Step two, install the digital certificate for the VBA project

Open Control Panel → add or Remove Programs → change or Remove Programs, locate Microsoft Office Professional Edition 2003 on the right, click Change, and then appear Microsoft Office 2003 installation. Select "Add or remove feature → next" in turn, select the Select Advanced Customization for Application check box, click Next, in Office sharing features, click the arrow to the left of digital certificate for VBA project, click Run from My Computer in the list, and then click Update. Insert Office installation disk to start installation.

Step three, create your own digital certificate

After the installation is successful. In the Startup Programs menu of Microsoft Office, select the digital certificate for Microsoft Office Tools →vba Project, and in the Create Digital Certificate dialog box, in the name of your certificate box, type a name for the digital certificate, and click OK You create your own digital certificate.

Step four, add a signature to the macro

Open the file created in step two, select tools → macros →visual Basic editor, select tools → digital signatures in the editor, click the Select button in the Digital Signature dialog box, select the digital certificate that you created in step four, and "OK" to return. Then select file → Close and return to Microsoft Excel to save and close the file.

Step five, add yourself as a trusted distributor

Open the file that contains the signed macro for step v. A warning appears, select the Always trust macros from this publisher check box, and click Enable Macros. When you open the Excel file again, no more security warnings are displayed. You can also use macros from the Tools menu to perform the macros you have created.