Home > Resources > Office Password > Protect Multiple Excel Sheets 2010

How to Protect Multiple Sheets in Excel 2010 Workbook

How to make Excel sheets 2010 safe? Protect multiple sheets with password is good way. Please follow below to protect your Excel sheets at once according to your wish.

Way 1: Protect Multiple Sheets with Protect function

1. Click Review on menu, and you would see Protect Sheet and Protect Workbook function.

protect mutiple excel sheets 2010 with protection function

2. Protect multiple sheets 2010 in workbook

Note: If you want to remove the sheet protection, just do it like when you protect it.

Way 2: Protect All Excel Sheets once with VBA

With VBA code, you can protect all worksheets on workbook once with the same password. Follow below to do.

1. Press ALT + F11 to load Visual Basic for Applications window.

2. Click Insert > Module in menu to write following VBA code for protecting workbook.

protect excel 2010 with vba code

3. Press F5 to run the VBA code. And type a password for all the sheets in pop-up dialog.

run vba code to set password for excel protection

4. Click OK and type the same password again to confirm.

confirm excel 2010 password in vba

5. Click OK and then all the worksheets on this workbook are protected with same password.

Way 3: Protect All Sheets on workbook with Excel Permissions

1. Click File – Info on workbook.

2. There is one option Protect Workbook Click it and select Encrypt with Password.

protect excel workbook with password

3. Type password in pop-up window and click OK.

encrypt excel 2012 with password

Way 4: Protect Part of Sheets in Workbook Once with Kutools for Excel

VBA gives us a way to protect all Excel sheets at once, but sometimes we don’t want to encrypt all the sheets, but only some of them. At this time, VBA becomes unavailable, but Kutools for Excel could make this possible.

1. Download Kutools for Excel and install it on your computer.
Open your workbook and you would see there are two additional options in Excel menu, Kutools and Enterprise.

protect some excel sheets with kutools once

2. Click Enterprise > Protect Worksheet and a new dialog pops up. Select sheets you want to protect and click OK.

3. Type password twice for these sheets we select just now. And then click OK.

select excel sheets for protectionset password to protect excel sheets 2010

Now, with the methods introduced above, multiple sheets on Excel workbook have been protected with password.

protect multiple excel 2010 with password

So please save these passwords in safe place. And when you want to open them next time, just need to type password. But if forgot or lost excel password, recover excel password would become first work before opening Excel sheets.

Related Articles:

Hot Categories
Windows Password
iTunes Password
Office Password
More +
Hot Articles
Locked Out of Office Files - How to Open
3 Ways to Remove Word Password
Forgot Excel Workbook 2010/2013/2016 Password | How to Do
How to Unlock Password Protected PowerPoint Presentation
How to Remove Forgotten Password from Access Database
More +
Latest Articles
How to Unprotect Excel Sheet/Worksheet/Workbook without Password
How to Recover Outlook 2016 PST File Forgotten Password
Office 2016 Password Recovery after Forgot or Lost
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +