Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect/unprotect a formula
I know how to protect a formula in a cell. However, when I do that, the flag
in the upper left corner of the cell disappears. I know, it is suppose to do that. But what do I do so that the flag reappears in the cell. Even when I unprotect the entire sheet, the flag still does not re-appear. HELP!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect/unprotect a formula
Flags keep on reappearing if a rule is broken, except when you protect the
sheet. When you unprotect they normally re-appear. However, if you untick the rule they refer to, they will not appear. Also, if you select a cell with such a green marker, then click on the exclamation mark and select Ignore rule, they are gone as well. -- HTH Kassie Replace xxx with hotmail "The Wabster" wrote: I know how to protect a formula in a cell. However, when I do that, the flag in the upper left corner of the cell disappears. I know, it is suppose to do that. But what do I do so that the flag reappears in the cell. Even when I unprotect the entire sheet, the flag still does not re-appear. HELP!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
Protect/unprotect all sheets at once? | New Users to Excel | |||
Protect / unprotect function | Excel Worksheet Functions | |||
Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
Protect / Unprotect with checkbox | Excel Discussion (Misc queries) |