View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
harmukh harmukh is offline
external usenet poster
 
Posts: 2
Default 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.