Easily protect multiple Excel workbooks with password at once

Normally, you can run VBA code to protect multiple workbooks in a folder with the same password at once. Here highly recommend the Encrypt Workbooks feature of Kutools for Excel, this feature helps to encrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with the same password at the same time.

Easily protect multiple Excel workbooks with the same password at once

The following steps demonstrate how the Encrypt Workbooks feature protect multiple workbooks at the same time with the same password.

1. Click Kutools Plus > Encrypt Workbooks > Encrypt Workbooks.

2. Then a Kutools for Excel dialog box pops up, click the OK button.

Note: Before protecting workbooks, make sure the workbooks are closed in case error occurring.

3. In the opening Encrypt Workbooks dialog box, you need to configure as follows.

4. Then a dialog box pops up to tell you how many workbooks are successfully encrypted, click OK to close it.

5. Then another dialog box pops up to ask for scenario saving. If you want to save current workbook configuration as a scenario, click Yes, otherwise, click No to finish the operation.

6. If you click the Yes button, a Save Scenario dialog box will open. You need to type a name for the scenario and then click OK button.

Now all selected workbooks are protected with the same password at once.

Tips:

1. After adding workbooks, if there are workbooks you do not want to protect, just uncheck or delete them, or you can remove all workbooks from the window by clicking the Clear all button.

2. Click to show password : Click this button to show the password in the textbox.

3. Passwords Manager : Click this button to use the password you have saved in the Password Manage to protect the currently selected workbooks. After clicking this button, a list box pops up with all saved passwords listing, click one of the passwords to fill in the textbox.

4. Include subfolders when adding folders: after adding a folder, you can check this option to include all workbooks in the subfolders.

5. : Click this button will open the Password Manager dialog box. Click to know how to use the Password Manager feature.

6. : Click this button to open the Open scenario dialog box.

Or you can click the drop-down arrow to display the other options:

• Open: Directly open the Open scenario dialog box. All saved scenarios are saved in this dialog. Select a scenario and then click OK will open it.
  
• Save: This option helps to save current workbook structure as a scenario. Click this option to open the Save Scenario dialog box, enter the scenario name and then click OK.
  
• Save as: This option helps to save current scenario as a new one.
• Manager: Click this option to open the Manager Scenario dialog box. In the dialog box, you can rename, delete and sort the saved scenarios as you need.