password protect

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

Thanks

Pete_UK
Tue Apr 15 14:42:59 CDT 2008

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

On Apr 15, 8:33=A0pm, "S" <vir...@blueyonder.co.uk> wrote:
> I have a workbook with 4 pages, is it possible to password protect just on=
e
> sheet to prevent it being opened.
>
> Thanks

Gord
Tue Apr 15 16:36:20 CDT 2008

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


On Tue, 15 Apr 2008 20:33:07 +0100, "S" <virgin@blueyonder.co.uk> wrote:

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

S
Tue Apr 15 17:31:19 CDT 2008

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.


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:co7a045t802katc03vpp74iou62gerrmvp@4ax.com...
> 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
>
>
> On Tue, 15 Apr 2008 20:33:07 +0100, "S" <virgin@blueyonder.co.uk> wrote:
>
>>I have a workbook with 4 pages, is it possible to password protect just
>>one
>>sheet to prevent it being opened.
>>
>>Thanks
>>
>