Note: The other languages of the website are Google-translated. Back to English
English English

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.

3.1) Add files: Click the Add button, and there are four options for you:
  • File(s): Select this option to open the Select File window, then choose the workbooks you need to protect;
  • Folder: Select this option to open the Select Folder window, then choose a folder which contains the workbooks you want to protect at once;
  • OneDrive File(s): Select this option, and then choose the workbooks you need to protect from a specific OneDrive account ;
  • OneDrive Folder: Select this option, and then choose a folder which contains the workbooks you want to protect at once from a specific OneDrive account.

Note: The OneDrive File(s) and OneDrive Folder options only support Excel 2013 and the later versions.

3.2) Then all selected workbooks are listed in the workbook window. You can click the list column headers (Workbook Name or Workbook Path) to sort the workbooks.

3.3) Specify a password: Enter a password into the Use the following password textbox.

3.4) Click the OK button to start protecting the workbooks.

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.

  If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations