| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I protect only formulas(functions) in a workbook?
I am creating an audit sheet for a hotel and need to have formulas that
employees can not change. But they need to be able to plug in numbers into the cells where the formulas are. |
|
#2
|
|||
|
|||
|
format the cells to be locked with the exception of the cells that you want
to be able to input data, then protect the worksheet "c weber" wrote: I am creating an audit sheet for a hotel and need to have formulas that employees can not change. But they need to be able to plug in numbers into the cells where the formulas are. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
| Excel 2002 "Protect Sheet", but allow "Hide Columns"? | Excel Worksheet Functions | |||
| Can I protect a spreadsheet from being deleted or moved? | Excel Discussion (Misc queries) | |||
| How to protect Option button in worksheet | Excel Worksheet Functions | |||
| Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
Hybrid Mode
