| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking formula in cells in without locking whole sheet
I have spreadsheet for people to use so that they can insert data but I dont
want them to be able to delete or change formula in the related cells. I am using Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
locking formula in cells in without locking whole sheet
For the cells the people are allowed to input data go:
Format....cells....protection...and uncheck the 'locked' box. Then protect the whole worksheet, this will allow them only to enter data in the cells you have formatted as not locked. "SuziQ" wrote: I have spreadsheet for people to use so that they can insert data but I dont want them to be able to delete or change formula in the related cells. I am using Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Locking Cells ... Without Protecting Sheet | Excel Discussion (Misc queries) | |||
| locking a formula to cells | Excel Discussion (Misc queries) | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Linear Mode
