Thread: how do I lock a cell's format but still allow to edit it's value?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how do I lock a cell's format but still allow to edit it's value?
Unlock the cell, but protect the sheet.

In xl2003 menus:
format|cells|protection tab

And
tools|protection|protect sheet



hitchb wrote:

--

Dave Peterson
Reply With QuoteReply With Quote