Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|