🚀 go-pugleaf

ron@bert.cs.byu.edu (Ron Snyder) writes:

>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.

I can think of two options.
1) place extra, blank rows (or rows with labels such as \-) in the range
   at the endpoints.  This won't work if the calling formulas cannot deal
   with blanks, but works for things like @sum.  You could also use some
   predetermined dummy values that the calling cell(s) would know to
   factor out of their formulas, like all zeros or all ones.
2) in WYSIWYG mode, you *can* "sort-of" hide a row, by changing its height
   to a ridiculously low number.

-JTT