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

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

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

On Fri, 17 Aug 2007 18:06:00 -0700, mike wrote:

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

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

Thank you everybody for your prompt reply.

"JE McGimpsey" wrote:

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

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

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!



"JE McGimpsey" wrote:

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

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 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?
--
David Biddulph

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

"JE McGimpsey" wrote:

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

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

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?


"David Biddulph" wrote:

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?
--
David Biddulph

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

"JE McGimpsey" wrote:

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

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

Is it a password to open the file or a password to unprotect the workbook?

Sounds like the former to me.

There is quite a difference in method used depending upon answer to above.

Workbook protection password removal at
http://www.mcgimpsey.com/excel/removepwords.html

File protection password removal at
http://www.mcgimpsey.com/excel/fileandvbapwords.html

No. There is not a simpler method to overcome your problem.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 01:37:01 -0700, Hello
wrote:

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?


"David Biddulph" wrote:

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?
--
David Biddulph

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

"JE McGimpsey" wrote:

Tools/Protection/Protect Sheet (cells should have their Locked property
set by default).

However, even if you enter a password, it's trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html


So assume that anyone who has access to your workbook has access to
everything in it.

In article ,
mike wrote:

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