Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to protect a cell but allow formula values only
Hello, i have a worksheet with some formulas in it. I
have the sheet protected, but there are some cells i cannot protect because if i do, values calculated by formulas will not populate them. When i leave them unprotected, there is a risk of people typing their own value in and erasing the formula. How can i truly protect my sheet? I want to alllow data to be populated in certain cells, but only by formulas, not by a user typing in whatever they want. Your help greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect cell but allow formula to work | Excel Discussion (Misc queries) | |||
Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
Locking cell to protect the formula | Excel Discussion (Misc queries) | |||
How do I protect a cell formula from being overwritten | Excel Discussion (Misc queries) | |||
How do I protect the cell from users entering values in Excel? | Excel Worksheet Functions |