| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
| How do I lock a stamp date/time formula for an entry on a row? | Excel Worksheet Functions | |||
| Lock Cell After Data Entry | Excel Discussion (Misc queries) | |||
| Lock cell entry | Excel Worksheet Functions | |||
| Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel | |||
Hybrid Mode
