worksheet protection

M

mike

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
 
G

Gord Dibben

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
 
R

Robnific

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
 
H

Hello

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!
 
D

David Biddulph

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?
 
H

Hello

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?
 
Top