Cant Protect a Workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gazza67 - 08 Sep 2007 16:13 GMT

Hi,

I am sure the answer to this must be simple but I just cant find it. I
have a worksheet that I want to protect (ie prevent all changes to),
so I go tools - protection - protect sheet. Strangely however, I can
still make changes to the sheet. Same if I say protect workbook.

Is there some override flag that I dont know about?

Gary

Reply to this Message

gazza67 - 08 Sep 2007 16:33 GMT

> Hi,
>
[quoted text clipped - 6 lines]
>
> Gary

OK I found the answer myself, you must make sure they are locked
before you do the protecting.

Reply to this Message

Bruce Sinclair - 10 Sep 2007 05:51 GMT

>> Hi,
>>
[quoted text clipped - 9 lines]
>OK I found the answer myself, you must make sure they are locked
>before you do the protecting.

Note also, that the protection you get with an xl file is weak at best. It
stops people of good will only :)

Reply to this Message