close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()