View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Robnific Robnific is offline
external usenet poster
 
Posts: 22
Default protecting worksheets

Use my add in James,
Hide
Protect
Unprotect
makes you happy!
www.allocator.nl
grtz
Robert


David Harrison schreef:

Hi, My last question i dont think i explained in enough detail.

I have a workbook shared across a few computers for my employees to view.
The only information they need to see is Sheet 1. However, i dont want them
to be able to view the content in sheet 2 and 3. Can i have confidential or
something like that or a password to type in before anything can be shown
when that sheet is selected.

I have tried password protect through tools but that only stops me entering
data rather than not being able to view the content.

Im sure i have done this before. Can anybody help?

Thanks

David