| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect cells in excel to prevent users from deleting formulae
TWO STEPS
Format Cells Protection Tick 'locked' for the cells you want to be protected untick it for any cells you don't want protected Then Tools Protection Protect Sheet Allow users to select only unlocked cells Put a password in -- Allllen "locking cells in excel" wrote: how do i protect cells in excel to prevent users from deleting formulae in my worksheets |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To Protect Excel documents and allowing only few cells to edit | Excel Worksheet Functions | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
| How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
| How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
