Password Protecting a worksheet

  • Thread starter Thread starter Conker10382
  • Start date Start date
C

Conker10382

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.
 
You can Hide the sheet (Format - Sheet - Hide) then protect the workbook.
This wil disallow unhide. You would need to unprotect to allow unhide...
 
Excel's worksheet protection isn't made for this kind of thing. It's easily
broken and all that private data can be available to anyone who really wants it.

If you have data that is sensitive and shouldn't be seen by others, then don't
put it in excel. If you have to put it in excel, then don't share it with
others.
 
Works like a charm! Accomplishes exactly what I needed! Thanks Sean!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
corrupted formula in protected worksheet 21
Protect and Unprotect all worksheets with macro 2
Password protect from viewing 2
How to I reset a forgotten Excel worksheet protection password? 3
I need help password protecting a worksheet 9
password protected worksheet 7
Password Protect Specific Range Of Cells 6

Back
Top