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?