Range("B1").Locked = False not working

[thecdnmole]

Any idea why this would not work (title description)? I had to use the following.

Please Login or Register  to view this content.

[davesexcel]

It works for me, do you have the sheet protected?
Here is the code without select.

Please Login or Register  to view this content.

[thecdnmole]

Thanks for the reply davesexcel. Yes it was protected, but I put the code in to unprotect and protect, but still got an error. This happened a coupld of days ago, now I can't find the exact module or sheet which was causing the error. But I did want to get away from the ".select" code, which did not work, which did seem odd as to why.

[thecdnmole]

I just tried this, and it did not work. Commented lines is what worked before. Error I get is "Unable to set the locked property of the range class".

Please Login or Register  to view this content.

I also tried this as above. When I hover over it, it comes up with "Application.Range("F7").Locked = True = False

Please Login or Register  to view this content.

[davesexcel]

Guess you might have to attach a sample workbook with the offending code.

[thecdnmole]

Not happening, sorry. I spent a half hour last week desensitizing same spreadsheet and making it small enough to be put on forum to no avail, and it was a much more complicated issue than this. I will just leave this as is and maybe I will figure it out in time.

[thecdnmole]

This could be why, the cell causing the problem is part of a merged cell. But how to cure? I know, the three golden rules of vba and excel, thou shall not use merged cells!