| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with "broken" formula!
A good while back I wrote the following formula:
=IF(PERSONAL.XLS!IsProtected.IsProtected(), "Protected", "Unprotected") This formula was designed to use conditional formating and display the words "Protected" or "Unprotected" in different colors to quickly identify if the worksheet is protected or not. Now that it is time to update the worksheet for a new year, the formula is broken! All I get is "#NAME?". Unfortunately I don't remember what I did, or understand what is going on well enough to debug, can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| look for a pipeID in a column and returns "broken" result | Setting up and Configuration of Excel | |||
| "broken" y-axis in Excel charts | Charts and Charting in Excel | |||
Threaded Mode
