excel spread sheet protection

[Guest]

Is there a way you can check the last entry or even any access into a
spread sheet? Is there a way to stop somebody from opening a spread sheet if
they are not welcome

 

[Paul B]

Stacey, file save as then under tools, may be called something else
depending on what version you have, general options, password to open
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thank you paul, that leaves it as read only and that it what I am trying to
change, I would like it so it can't be read. The computer is used by
different people in the office and most spread sheets and programs have to be
accessed it's just one or to personal files should be kept that way,personal.
Is there any other way?

 

[Paul B]

Stacey, sounds like you put in a password to modify, it will open in read
only, if you select password to OPEN it will ask for a password before the
file opens, so you can't see anything in the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thanks again Paul, In tools all I can see id protect sheet and protect work
book I tried both and they let me open the spread sheet. Can you tell me
where to do this or maybe what I am doing wrong? Thanks Stacey

 

[Paul B]

Stacey, you are looking under the wrong menu, form the file menu, save as,
there is a tools under it, could be called options...., general options,
from there put in a password to open the file, OK, confirm the password, OK,
Save.
The next time you open the workbook you will be asked for a password first.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thank you, that was what I was looking for. Thanks Stacey

 

[Paul B]

Your Welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003