excel spread sheet protection


G

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
 
Ad

Advertisements

P

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
 
G

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

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
 
G

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
 
P

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
 
Ad

Advertisements

Ad

Advertisements

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top