🚀 go-pugleaf

SOFTWARE: Quattro Pro 3.01

  I have some budget sheets that are used by several accountants
in my department.  The budget have many(!) named ranges that are 
accessed by other worksheets.  Today one of the area heads called 
me because a summary worksheet that refers to these named ranges
is giving the wrong answers (like ERR).  It didn't take long to 
figure out that between he and his accountants, some of the endpoints
of the named ranges had been inadvertently deleted while they were 
'cleaning' up the budget worksheet.

  Protecting those rows doesn't work, because sometimes those ranges 
really _do_ need to be deleted, and I don't want them calling me 
everytime they want to delete lines in the worksheet.  (They don't want
that, either. :))

  Ideally, Borland would have a "Hide Row" option that is similar to 
the "Hide Column" option, so that I could hide the top and bottom of
the named ranges, but I am 99% sure that this handy little gadget is
a figment of my wishes.

  If you have had this problem, how did you overcome it?  (Yeah, I know
the best answer is to educate my users, but I feel like this problem
falls into the realm of "dummy-proofing".)

  Thanks in advance for any help you can give me!

--
Ron Snyder <ron@bert.cs.byu.edu>   <snyderrj@coned1.byu.edu>
****************************************************************