| 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 | |||
Hybrid Mode
