Re: Password Protect a Worksheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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:

Tools>Share 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 File>Save as>Tools>General Options and you will have
two password dialogs available.


Gord


On Sat, 27 Oct 2007 18:31:00 -0700, harmukh <harmukh@xxxxxxxxxxxxxxxxxxxxxxxxx>
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"
<joinme4coffee@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
work*** 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 work*** and the "Password to open"
box is not available. The "password to edit" box is OK.




.

Quantcast