View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Password Protecting a worksheet

You can Hide the sheet (Format - Sheet - Hide) then protect the workbook.
This wil disallow unhide. You would need to unprotect to allow unhide...

"Conker10382" wrote:

Can anyone tell me if there is a way to password lock only a specific
worksheet inside of a workbook? I would like all of my direct reports to be
able to access the workbook but not be able to access a certain page within
it, because it will contain associate personal information, unless they have
a password.

Thanks for any responses.