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.
Toolsgt;Protectiongt;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
gt; wrote:
gt;
gt;Hi
gt;
gt;Is it possible to password protect individual sheets? I have a workbook
gt;where i want to restrict access to certain sheets (i.e. by using a
gt;password)
gt;
gt;thanks
gt;
gt;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:
gt; Select the sheet to protect.
gt;
gt; ToolsProtectionProtect sheet. At this point enter a password and OK.
gt;
gt; Note: sheet protection passwords are easily cracked by average users
gt; so no
gt; guarantees that the access will not be compromised.
gt;
gt; If you don't want others to see data, do not include that data in the
gt; workbook.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Mon, 6 Mar 2006 13:06:38 0000, rufusf
gt; wrote:
gt;
gt;
gt; Hi
gt;
gt; Is it possible to password protect individual sheets? I have a
gt; workbook
gt; where i want to restrict access to certain sheets (i.e. by using a
gt; password)
gt;
gt; thanks
gt;
gt; rufusf--
rufusf
- Jul 16 Mon 2007 20:38
password protect sheets
close
全站熱搜
留言列表
發表留言