View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default worksheet protection

Is it a password to open the file or a password to unprotect the workbook?

Sounds like the former to me.

There is quite a difference in method used depending upon answer to above.

Workbook protection password removal at
http://www.mcgimpsey.com/excel/removepwords.html

File protection password removal at
http://www.mcgimpsey.com/excel/fileandvbapwords.html

No. There is not a simpler method to overcome your problem.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 01:37:01 -0700, Hello
wrote:

Well it's a little above my level. Note I do not know codes - just a basic
office user. Is there a simpler method to overcome my problem?


"David Biddulph" wrote:

You say you are interested in Mr McGimpsey's comments, so did you follow the
advice in the link he provided as to how to unlock the password?
--
David Biddulph

"Hello" wrote in message
...
Hi I'm interested in McGimpsey's comments.

I am the author of an excel 2007 spreadsheet with lots of formulas. I
closed the file to go to the washroom and when I reopened the file just a
few
minutes later, I was asked for a password. I did not password protect or
if
I did, it was accidental, since the protection is a obvious button on the
ribbon.

How can I remove/bypass the password? since I really don't want to have to
re-think the formulas and also how to link them all together!


"JE McGimpsey" wrote:

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

Hello everybody, I just want to ask how to protect our worksheet. I
mean if
somebody who open my worksheet, he/she can read only. They can't
change or
save the worksheet.

thanks