Add a password to a document in bulk with a macro command

For security reasons, many people add passwords to Office documents and, for memory purposes, may use the same password for all Office documents. However, it is cumbersome to repeat the process of document encryption every new document is edited. Here's a good way to automatically add a unified password to all of the specified Office documents, and we'll take word 2007 for example.

STEP1: First click the "view → macro → record macro" command, pops up the Record Macro dialog box, type the name password for the macro in the Macro Name field, select the all Documents (NORMAL.DOTM) option in the Save macros in column, and type a description of the macro in the Description box, such as Automatically add a unified password to the new document, and then click OK to start recording the macro.

STEP2: Click the Office Button, position the cursor to the Prepare option, automatically display the prepare menu on the right, select the Encrypt document tab, eject the Encrypt Document dialog box, enter the password you want to set in the Password box, and click OK. Then the system will pop up the confirmation dialog again, just enter the password again, and then click the "OK" button again.

STEP3: Click the view → macro command again, click the Stop Recording Macro button, and then click the View Macro button to see the macro you just recorded.

After Setup, the password macro runs automatically every time the document is closed. So when we create a new or open any document and close or exit, the program asks if you want to save the changes to the document, and if you click Yes, the document will be added with a password, and click No to add the password. How, the introduction of this method is not very convenient!