Greetings All:

Looking to control some large spread-sheets (SS) by the use of hide/unhide
toggles.

The application is such that on the larger "groupings" in the SS, the user
can "collapse" that grouping if it is not needed, in order to "shorten" the
SS.

In order to determine if my application is feasible, I'd like to get some
confirmation of a few basic items first.
1: Are custom dialog boxes the only way to create toggles?, or is there a
way to do this IN SS cells - (if so, how?)
2: If custom dialog boxes are the (only) way to go, is there a way to "lock"
the dialog box onto a specific cell? (if so, how?)
My experience to date with dialog boxes is that the box looses its
"position" within the SS when rows are added or deleted above that location.
3: Assuming we're doing OK, so far, is there a way to have a duplicate
toggle that works on a given range - One at the "top" of the range and one at
the "bottom".
I'm picturing the lite switches one has at the top and at the bottom of a
stairway, that operates the same lite(s). (also, if so, how?)

Thank-you