Protecting 1 Worksheet within a Workbook
 

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?

Protecting 1 Worksheet within a Workbook
 

You would hide the worksheet then Protect the Workbook under
ToolsProtectionProtect 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

On Thu, 12 Jul 2007 13:38:06 -0700, MRH wrote:

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?