View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Locking Cell Once Data is entered

Try either of the following:
1) Tools Protection Protect Sheet
2) Tools Protection Allow Users to Edit Ranges...

This is a great reference:
http://j-walk.com/ss/excel/faqs/protectionFAQ.htm


This is worth a look too:
http://www.techonthenet.com/excel/cells/protect.php



Regards,
Ryan--



--
RyGuy


"Wm Pincumbe" wrote:

Is there a way to lock a cell from being changed once data has been entered
into that cell?