password protect

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S - 15 Apr 2008 20:33 GMT

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

Thanks

Reply to this Message

Pete_UK - 15 Apr 2008 20:42 GMT

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

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

Reply to this Message

Gord Dibben - 15 Apr 2008 22:36 GMT

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

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

Reply to this Message

S - 15 Apr 2008 23:31 GMT

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.

> You can hide a worksheet through Format>Sheet>Hide then Protect the
> Workbook to
[quoted text clipped - 13 lines]
>>
>>Thanks

Reply to this Message