How to protect one sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S - 12 Apr 2008 09:02 GMT

I have a workbook with 4 pages, I want to deny access (to view) to just one
of those sheets but allow access to the other 3.
Is this possible

thanks

Reply to this Message

muddan madhu - 12 Apr 2008 09:35 GMT

go to tools | protect sheet | ok

u can also set password

> I have a workbook with 4 pages, I want to deny access (to view) to just one
> of those sheets but allow access to the other 3.
> Is this possible
>
> thanks

Reply to this Message

Gord Dibben - 12 Apr 2008 16:45 GMT

Muddan

How will that prevent users from "viewing" the sheet?

Gord

>go to tools | protect sheet | ok
>
[quoted text clipped - 5 lines]
>>
>> thanks

Reply to this Message

Gord Dibben - 12 Apr 2008 16:44 GMT

You can hide the worksheet at Format>Sheet>Hide.

Then Tools>Protection>Protect Workbook with a password.

Note: Excels internal security is very weak, but the above may keep the truly
non-inquisitive from cracking your password.

Gord Dibben MS Excel MVP

>I have a workbook with 4 pages, I want to deny access (to view) to just one
>of those sheets but allow access to the other 3.
>Is this possible
>
>thanks

Reply to this Message

Rate this thread: