Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting formulas
Hello, I've been working on a daily log for the guys that work with me. I was wondering if there is a way to protect formulas in a cell. So if the guys hit delete or such they will not delete the formula. So all my calculations will be correct. But I still need it to where the guys can still add info in those cells. Thanks, Shaunna |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting formulas
If you have a formula in the cell, and it is typed in, the formula would then
be removed. If you are OK with this, there is no way to allow the cell to be typed in but not deleted. If you want to protect/unprotect only certain cells, go to Format - cells - Protection and select/deselect Locked. Then Go to Tools - Protection - Protect sheet. "Shaunna" wrote: Hello, I've been working on a daily log for the guys that work with me. I was wondering if there is a way to protect formulas in a cell. So if the guys hit delete or such they will not delete the formula. So all my calculations will be correct. But I still need it to where the guys can still add info in those cells. Thanks, Shaunna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROTECTING FORMULAS | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Discussion (Misc queries) | |||
Protecting my formulas | Excel Discussion (Misc queries) | |||
Protecting Formulas | New Users to Excel | |||
Protecting formulas | Excel Discussion (Misc queries) |