View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How can I lock formulas but allow date entry in a cell

Select cells to be entered. Right click FormatCells|Protection|Uncheck locked
and Protect sheet.

If this post helps click Yes
---------------
Jacob Skaria


"Monterey" wrote:

Is there a way to lock formulas but allow for data to be entered or deleted?
I need to create a sales spreadsheet for a client to record their sales and
deposits, but I do not want them to change the formulas.