worksheet protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You could save as and place a password to modify on the workbook.

User would need the password else workbook is opened as read-only.


Gord Dibben MS Excel MVP
 
Yes, you can do all that all the time for all your sheets and
workbook.
Comes a time you forgot all about it.
You need an add-in
Lucky 4 you you can rely on James to handle all your files in once :
http://www.allocator.nl

Robert MS XL VSP
 
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!
 
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?
 
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?
 
Back
Top