Locked Property Error
 

Hey guys,

In one of my macros, I am trying to unlock a given cell by saying
Cells(row number, column letter).Locked = False. I have used it before
and it worked, but for some reason, I keep getting an error which
states:

Run-time error '1004':

Unable to set the Locked property of the Range class

The sheets are unprotected so that shouldn't be an issue. Does anyone
know how to fix this? Thanks in advance and please let me know if you
need more information.


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=470601

Locked Property Error
 

Is the cell/range merged?

This worked ok when I merged A1:B1
Cells(1, 1).MergeArea.Locked = False

Maybe the rownumber and/or columnletter weren't correct?




Raman325 wrote:

Hey guys,

In one of my macros, I am trying to unlock a given cell by saying
Cells(row number, column letter).Locked = False. I have used it before
and it worked, but for some reason, I keep getting an error which
states:

Run-time error '1004':

Unable to set the Locked property of the Range class

The sheets are unprotected so that shouldn't be an issue. Does anyone
know how to fix this? Thanks in advance and please let me know if you
need more information.

--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=470601

--

Dave Peterson

Locked Property Error
 

Thank you for the response. I checked the reference t omake sure it wa
correct and it was fine. It is part of a merged cell, however. If I us
the MergedArea reference like you have used, will it work on cells tha
haven't been merged as well

--
Raman32
-----------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=47060

Locked Property Error
 

What happened when you tried it?

(It worked ok for me.)

Sometimes, it's just quicker to try it out.

Raman325 wrote:

Thank you for the response. I checked the reference t omake sure it was
correct and it was fine. It is part of a merged cell, however. If I use
the MergedArea reference like you have used, will it work on cells that
haven't been merged as well?

--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=470601

--

Dave Peterson

Locked Property Error
 

Yes it will, but how easy would it have been to test it?

--
Regards,
Tom Ogilvy


"Raman325" wrote in
message ...

Thank you for the response. I checked the reference t omake sure it was
correct and it was fine. It is part of a merged cell, however. If I use
the MergedArea reference like you have used, will it work on cells that
haven't been merged as well?


--
Raman325
------------------------------------------------------------------------
Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=470601

Locked Property Error
 

Sorry about that, unfortunately, I did not have access to the macro when
I had sent you that response. Thanks again for your help.


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=470601