ExcelBanter - unlock a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - unlock a cell (https://www.excelbanter.com/excel-programming/309758-unlock-cell.html)

Jean-Paul De Winter

unlock a cell

Hi,
What is the correct VB syntax to unlock a cell?
Thanks

Tom Ogilvy

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

Jean-Paul De Winter

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

Tom Ogilvy

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

All times are GMT +1. The time now is 11:02 PM.