VBA error - Unble to set the Locked property of the Range class

**Libster78** · 01-25-2010, 05:31 PM

Hi all,

I am having trouble with a macro for unprotecting a sheet keeping specific cells locked then clearing contents of other cells then reproect the sheet.

I wrote one for one sheet which works and I have re used this but it keeps saying Unable to set the Locked property of the Range class.

Can anyone see what I've done wrong?

Please Login or Register  to view this content.

The code that worked is:

Please Login or Register  to view this content.

I don't know why it works with one sheet and not the other.

All help gratefully recieved.

I have attached the sheet in case its something on the sheet rather than the code,

Thanks again

**romperstomper** · 01-25-2010, 05:51 PM

Try this version, which fully qualifies the references:

Please Login or Register  to view this content.

**Leith Ross** · 01-25-2010, 05:53 PM

Hello Libster78,

When using the With stement, you need to be mindful of periods before properties and methods of the object With refers to. There is period missing before cells. Without the period, the ActiveSheet is assumed to be the object of reference.

Please Login or Register  to view this content.

**Libster78** · 01-25-2010, 06:14 PM

Thank you so much. I have been trying to do that all day.

Its working perfectly now.

**upsipo** · 03-01-2013, 04:16 PM

Here is the solution. I am a beginner with VBA and far far far from being a Guru. But I had the same problem and spend 2 days over the internet to find the solution. It has something to do with Merged Cells (Excel which is a product of Microsoft - a corporation who does not give a ***** about its clients) did not bother to tell anybody about the merged cell problem.
Well I used to have
.Range("D4").Locked = True Which gave me a 1004 error continuosly
Now I changed it to
.Range("D4").MergeArea.Locked = True and it is working !!!!!