Lock All Cells in Worksheet

[Bob1980]

Good Afternoon,

This should be an easy one, and I'm a little embarrassed about not figuring it out.

Is there a way that I can lock all of the cells in a worksheet without referencing the range of the worksheet? I was using the following code to do it before, but it magically stopped working. I'm getting a "Compile error" Method or data member not found" message. Here is the code:

Please Login or Register  to view this content.

The compile error is occurring on the "Locked" method. It was working before, but now it doesn't work. Strange.

Thanks,
Bob

[6StringJazzer]

I'm sorry to doubt you but I don't think that code ever worked. There is no Locked attribute available for a worksheet object. You want this:

Please Login or Register  to view this content.

What does this mean: "without referencing the range of the worksheet"?

[jaslake]

Hi Bob

Try this (not tested)

Please Login or Register  to view this content.

[Bob1980]

You are right. Thanks, it's like my code is magically changing by it's self. Thanks a bunch.

Bob