View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default worksheet protection

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