excel spread sheet protection
 

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

excel spread sheet protection
 

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

"stacey" wrote in message
...
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

excel spread sheet protection
 

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" wrote:

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

"stacey" wrote in message
...
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

excel spread sheet protection
 

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

"stacey" wrote in message
...
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" wrote:

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

"stacey" wrote in message
...
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

excel spread sheet protection
 

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" wrote:

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

"stacey" wrote in message
...
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" wrote:

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

"stacey" wrote in message
...
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

excel spread sheet protection
 

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

"stacey" wrote in message
...

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" wrote:

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

"stacey" wrote in message
...
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" wrote:

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

"stacey" wrote in message
...
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

excel spread sheet protection
 

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

"Paul B" wrote:

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

"stacey" wrote in message
...

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" wrote:

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

"stacey" wrote in message
...
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" wrote:

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

"stacey" wrote in message
...
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

excel spread sheet protection
 

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

"stacey" wrote in message
...
Thank you, that was what I was looking for. Thanks Stacey

"Paul B" wrote:

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

"stacey" wrote in message
...

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" wrote:

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

"stacey" wrote in message
...
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" wrote:

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

"stacey" wrote in message
...
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