ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Locking cells (https://www.excelbanter.com/excel-programming/274593-re-locking-cells.html)

Chip Pearson

Locking cells
 
Ian,

Try something like

Range("A1").Locked = True ' or False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ian Coates" wrote in message
...
Is there a way to lock a cell using VBA?






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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com