| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Password Protect a Worksheet
Help! I am trying to password protect a worksheet and the "Password to open"
box is not available. The "password to edit" box is OK. |
|
#2
|
|||
|
|||
|
hi there,
if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#3
|
|||
|
|||
|
I am using the first option you list. The entry box for password to open is
grayed out. the box for password to modify is available Thanks for your help! "salooha" wrote: hi there, if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#4
|
|||
|
|||
|
If you really mean "worksheet" and not "file" then click on
ToolsProtectionProtect Sheet(or workbook). Gord Dibben Excel MVP On Mon, 15 Aug 2005 11:47:08 -0700, "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#5
|
|||
|
|||
|
My guess is that the file is shared.
The "password to open" will be grayed out in that case. Gord Dibben Excel MVP On Mon, 15 Aug 2005 12:27:02 -0700, "joinme4coffee" wrote: I am using the first option you list. The entry box for password to open is grayed out. the box for password to modify is available Thanks for your help! "salooha" wrote: hi there, if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Password Protect a Worksheet
How does one find out if the file is "shared" and how do you "un-share" it
thanks "Gord Dibben" wrote: My guess is that the file is shared. The "password to open" will be grayed out in that case. Gord Dibben Excel MVP On Mon, 15 Aug 2005 12:27:02 -0700, "joinme4coffee" wrote: I am using the first option you list. The entry box for password to open is grayed out. the box for password to modify is available Thanks for your help! "salooha" wrote: hi there, if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Password Protect a Worksheet
ToolsShare Workbook.
If it is shared the "allow etc." checkbox will be checked. Uncheck it to un-share. Note: the workbook will save itself when you click on OK Now you can go back into FileSave asToolsGeneral Options and you will have two password dialogs available. Gord On Sat, 27 Oct 2007 18:31:00 -0700, harmukh wrote: How does one find out if the file is "shared" and how do you "un-share" it thanks "Gord Dibben" wrote: My guess is that the file is shared. The "password to open" will be grayed out in that case. Gord Dibben Excel MVP On Mon, 15 Aug 2005 12:27:02 -0700, "joinme4coffee" wrote: I am using the first option you list. The entry box for password to open is grayed out. the box for password to modify is available Thanks for your help! "salooha" wrote: hi there, if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Password Protect a Worksheet
Thanks for the response. I don't have the "allow etc." checkbox checked. I
still don't see the "password to open" option enabled. I tried checking and un-checking too, with no results. Appreciate any help. thanks "Gord Dibben" wrote: ToolsShare Workbook. If it is shared the "allow etc." checkbox will be checked. Uncheck it to un-share. Note: the workbook will save itself when you click on OK Now you can go back into FileSave asToolsGeneral Options and you will have two password dialogs available. Gord On Sat, 27 Oct 2007 18:31:00 -0700, harmukh wrote: How does one find out if the file is "shared" and how do you "un-share" it thanks "Gord Dibben" wrote: My guess is that the file is shared. The "password to open" will be grayed out in that case. Gord Dibben Excel MVP On Mon, 15 Aug 2005 12:27:02 -0700, "joinme4coffee" wrote: I am using the first option you list. The entry box for password to open is grayed out. the box for password to modify is available Thanks for your help! "salooha" wrote: hi there, if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Password Protect a Worksheet
The only thing I know of that would gray out the "password to open" and leave
"password to modify" available is if the workbook is shared so I can't be of any help if you have established that the workbook is not shared. Hopefully someone will have another idea. Gord On Sun, 28 Oct 2007 10:55:01 -0700, harmukh wrote: Thanks for the response. I don't have the "allow etc." checkbox checked. I still don't see the "password to open" option enabled. I tried checking and un-checking too, with no results. Appreciate any help. thanks "Gord Dibben" wrote: ToolsShare Workbook. If it is shared the "allow etc." checkbox will be checked. Uncheck it to un-share. Note: the workbook will save itself when you click on OK Now you can go back into FileSave asToolsGeneral Options and you will have two password dialogs available. Gord On Sat, 27 Oct 2007 18:31:00 -0700, harmukh wrote: How does one find out if the file is "shared" and how do you "un-share" it thanks "Gord Dibben" wrote: My guess is that the file is shared. The "password to open" will be grayed out in that case. Gord Dibben Excel MVP On Mon, 15 Aug 2005 12:27:02 -0700, "joinme4coffee" wrote: I am using the first option you list. The entry box for password to open is grayed out. the box for password to modify is available Thanks for your help! "salooha" wrote: hi there, if you go file -- save as -- then click on tools -- general options, there should be a couple of entry boxes, one for password to open and the other is for password to modify. this is one way to password protect the worksheet from opening without authorization. the other way which I am assuming you're asking about is if you go to tools -- options -- 'security' tab. there should be two entry boxes as well, one says password to open and the other password to modify..is this what you're talking about?? can you please ellaborate a little? -- Thanks, salah http://leitek.com "joinme4coffee" wrote: Help! I am trying to password protect a worksheet and the "Password to open" box is not available. The "password to edit" box is OK. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unprotect cells in a worksheet when I have forgotten the password | Excel Discussion (Misc queries) | |||
| Can specific cells on a worksheet be hidden & password protected? | Excel Worksheet Functions | |||
| How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) | |||
| Auto Protect workbook with password upon opening | Excel Worksheet Functions | |||
| lost my password (worksheet protect) | Excel Discussion (Misc queries) | |||
Linear Mode
