Passwording
 

Is it possible to password a worksheet with in a document so that it can not
be viewed by anyone without that password. I know I can set it so that it can
not be changed without the password.

Hi
in the saveas dialog you can set a Read password

--
Regards
Frank Kabel
Frankfurt, Germany

"celake" schrieb im Newsbeitrag
...
Is it possible to password a worksheet with in a document so that it
can not
be viewed by anyone without that password. I know I can set it so
that it can
not be changed without the password.

Doesnt' that do the whole workbook though? I am curious for just a worksheet
within the workbook.

"Frank Kabel" wrote:

Hi
in the saveas dialog you can set a Read password

--
Regards
Frank Kabel
Frankfurt, Germany

"celake" schrieb im Newsbeitrag
...
Is it possible to password a worksheet with in a document so that it
can not
be viewed by anyone without that password. I know I can set it so
that it can
not be changed without the password.

Hi
for just a worksheet you'll have to create a macro but this kind of
protection can easily be circumnvented

--
Regards
Frank Kabel
Frankfurt, Germany

"celake" schrieb im Newsbeitrag
...
Doesnt' that do the whole workbook though? I am curious for just a
worksheet
within the workbook.

"Frank Kabel" wrote:

Hi
in the saveas dialog you can set a Read password

--
Regards
Frank Kabel
Frankfurt, Germany

"celake" schrieb im Newsbeitrag
...
Is it possible to password a worksheet with in a document so that
it
can not
be viewed by anyone without that password. I know I can set it so
that it can
not be changed without the password.

to password protect worksheet.

go to tools-protection-protect sheet- select
contents,objects,scenerio , enter password and reenter password when it
prompts for re-confirm password, click ok.

now your worksheet is password protected.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277054

You can hide the worksheet then ToolsProtectionProtect Workbook.

Users can open and edit the visible sheets, but need the password to get at
the hidden sheet.

Gord Dibben Excel MVP

On Wed, 10 Nov 2004 08:49:03 -0800, celake
wrote:

Is it possible to password a worksheet with in a document so that it can not
be viewed by anyone without that password. I know I can set it so that it can
not be changed without the password.

Thanks :)

"Gord Dibben" wrote:

You can hide the worksheet then ToolsProtectionProtect Workbook.

Users can open and edit the visible sheets, but need the password to get at
the hidden sheet.

Gord Dibben Excel MVP

On Wed, 10 Nov 2004 08:49:03 -0800, celake
wrote:

Is it possible to password a worksheet with in a document so that it can not
be viewed by anyone without that password. I know I can set it so that it can
not be changed without the password.