Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlock a cell
Hi,
What is the correct VB syntax to unlock a cell? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlock a cell
with the sheet unprotected
activeCell.Locked = False -- Regards, Tom Ogilvy "Jean-Paul De WInter" wrote in message ... Hi, What is the correct VB syntax to unlock a cell? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlock a cell
Thanks for the reply...
However, I need to unlock cells A1 to A3 so what will be the syntax then? Greets JP "Tom Ogilvy" schreef in bericht ... with the sheet unprotected activeCell.Locked = False -- Regards, Tom Ogilvy "Jean-Paul De WInter" wrote in message ... Hi, What is the correct VB syntax to unlock a cell? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlock a cell
Range("A1:A3").Locked = False
the sheet has to be unprotected when you do this. -- Regards, Tom Ogilvy "Jean-Paul De WInter" wrote in message ... Thanks for the reply... However, I need to unlock cells A1 to A3 so what will be the syntax then? Greets JP "Tom Ogilvy" schreef in bericht ... with the sheet unprotected activeCell.Locked = False -- Regards, Tom Ogilvy "Jean-Paul De WInter" wrote in message ... Hi, What is the correct VB syntax to unlock a cell? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I Unlock cell/worksheet? | Excel Discussion (Misc queries) | |||
Dynamic unlock a cell (under condition) | Excel Discussion (Misc queries) | |||
Dynamic unlock a cell (under condition) | Excel Worksheet Functions | |||
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
Lock / Unlock Cell | Excel Programming |