| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection
I know its basic but how do i protect a sheet so that when i delete an entry
i dont delete the formula? Thanks James |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protection
All cells on a worksheet are "Locked" by default. When you apply Protection
to the sheet, with or without a password, you can no longer make changes to Locked cells. So begin by selecting and using Format -- Cells -- Protection to "Unlock" the cells you DO want to be able to make changes to, as in deleting some user input. Leave the ones with formulas in them locked. Then apply Protection to the sheet. You can select more than one cell at a time to unlock, but I usually make a boo-boo somewhere, so I'll grab a few at a time and unlock them and then choose some more and repeat until I'm all done. You can also choose entire rows or columns to unlock/lock. "james" wrote: I know its basic but how do i protect a sheet so that when i delete an entry i dont delete the formula? Thanks James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Linear Mode
