Hi Amy
Selection.Locked = True
Selection.Locked = False
Or
Range("A1:c10").Locked = True
Or all cells on the worksheet
Cells.Locked = True
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Amy" wrote in message ...
How do I lock/unlock cells in code?