| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect formulas but allow deletion of rows?
I have a sheet where all the formulas must be preserved exactly, but I want
users to be able to delete rows with cells containing those protected formulas. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect formulas but allow deletion of rows?
Maybe you could give them a macro that would unprotect the worksheet, do the row
deletion and then reprotect the worksheet. You could even build checks into your code that only certain rows can be deleted. Hubitron2000 wrote: I have a sheet where all the formulas must be preserved exactly, but I want users to be able to delete rows with cells containing those protected formulas. Is this possible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding new rows and keeping same formulas | Excel Discussion (Misc queries) | |||
| Question about deleting rows and formulas | Excel Discussion (Misc queries) | |||
| how to protect formulas in a cell | Excel Discussion (Misc queries) | |||
| How do i protect formulas in excel from being deleted? | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
Linear Mode
