Thread: locking cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default locking cells

Cells are locked by default but has no bearing until you protect the
Worksheet. IF only 4 cells, Ctrl+A Format cell - Protection - unchecked
Locked. Now select your 4 cells and Lock them, then protect the Worksheet.


--
Regards
Dave Hawley
www.ozgrid.com
"rwbaker" wrote in message
...
excel version 2003
i have 4 cells that once one is select i dont want the user to be able to
type in the others
is there anyway to control this