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.
1. Click Review on menu, and you would see Protect Sheet and Protect Workbook 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.
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.
3. Press F5 to run the VBA code. And type a password for all the sheets in pop-up dialog.
4. Click OK and type the same password again to confirm.
5. Click OK and then all the worksheets on this workbook are protected with same password.
1. Click File – Info on workbook.
2. There is one option Protect Workbook Click it and select Encrypt with Password.
3. Type password in pop-up window and click OK.
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.
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.
Now, with the methods introduced above, multiple sheets on Excel workbook have been protected 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.
Password Recovery Software