password protect

  • Thread starter Thread starter S
  • Start date Start date
S

S

I have a workbook with 4 pages, is it possible to password protect just one
sheet to prevent it being opened.

Thanks
 
Yes. Select the sheet then click on Tools | Protection | Protect Sheet
and give it a password (twice - write it down to remember it as well).
You can also hide the worksheet (Format | Sheet | Hide), so it's not
obvious it is there.

However, bear in mind that Excel passwords are not very secure and can
easily be broken by someone who is determined.

Hope this helps.

Pete
 
You can hide a worksheet through Format>Sheet>Hide then Protect the Workbook to
prevent the sheet being unhidden.

Tools>Protection>Protect Workbook.

Excel's internal security is quite weak, so don't rely on a password to keep
snoopers out.


Gord Dibben MS Excel MVP
 
Thanks for replies.
It probably wont help as I have to protect the workbook for the person I am
doing it for to stop her messing it up (nightmare)
There is just one sheet that she might not want her staff to see But if she
is allowed to protect/unprotect the workbook she will screw it up in 5
minutes.
I will just advise her to hide the sheet concerned (Its not life threatening
if the staff do access it)

appreciate your time guys.
 
Back
Top