| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked Property off, but cannot select cell | Excel Discussion (Misc queries) | |||
| Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
| Unable to set the Locked property of the range class | Excel Programming | |||
| Userform and controls locked property | Excel Programming | |||
![Raman325[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
