View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steveb steveb is offline
external usenet poster
 
Posts: 16
Default 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?