Protecting 1 Worksheet within a Workbook

[MRH]

How do you password secure a single worksheet within a workbook to where
users with out access can't view the protected worksheet, but can view the
other unprotected worksheets?

 

[Gord Dibben]

You would hide the worksheet then Protect the Workbook under
Tools>Protection>Protect Workbook with a password.

Note: Excel's internal security is quite weak and passwords are easily broken.

You could make the sheet veryhidden using VBA code then you wouldn't have to
protect the workbook and you would need more code to unhide it.

In that case you lock the VBAProject for viewing with a password.

This type of password is more difficult to crack.......but can be done.


Gord Dibben MS Excel MVP