Hi
Is it possible to password protect individual sheets? I have a workbook
where i want to restrict access to certain sheets (i.e. by using a
password)
thanks
rufusf
--
rufusf
Hi
Is it possible to password protect individual sheets? I have a workbook
where i want to restrict access to certain sheets (i.e. by using a
password)
thanks
rufusf
--
rufusf
Select the sheet to protect.
Tools>Protection>Protect sheet. At this point enter a password and OK.
Note: sheet protection passwords are easily cracked by average users so no
guarantees that the access will not be compromised.
If you don't want others to see data, do not include that data in the workbook.
Gord Dibben MS Excel MVP
On Mon, 6 Mar 2006 13:06:38 +0000, rufusf
<[email protected]> wrote:
>
>Hi
>
>Is it possible to password protect individual sheets? I have a workbook
>where i want to restrict access to certain sheets (i.e. by using a
>password)
>
>thanks
>
>rufusf
Apologies - what I meant is password protect access to the sheet (not
protect data) so that when you select the sheet it can only be
displayed after entering a password?
Thanks
rufusf
Gord Dibben Wrote:
> Select the sheet to protect.
>
> ToolsProtectionProtect sheet. At this point enter a password and OK.
>
> Note: sheet protection passwords are easily cracked by average users
> so no
> guarantees that the access will not be compromised.
>
> If you don't want others to see data, do not include that data in the
> workbook.
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 6 Mar 2006 13:06:38 +0000, rufusf
> [email protected] wrote:
>
>
> Hi
>
> Is it possible to password protect individual sheets? I have a
> workbook
> where i want to restrict access to certain sheets (i.e. by using a
> password)
>
> thanks
>
> rufusf
--
rufusf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks