In , David McRitchie
spake thusly:

Hiding or unhiding a row or column is not an event that can
be checked for, see the top of the page.
http://www.mvps.org/dmcritchie/excel/event.htm
besides it can be done by hiding row or done by using subtotal
buttons and I don't think they are the same.

David, thank you. I was saving this until I had time to study
it and concentrate. That took about 12 days to happen, because
my work has been extremely harried and I had some deadlines going.

In any case, I've looked further at this now, and your and others'
help with my question is appreciated. I'm meanwhile re-doing the
entire set of sheets for this task, also. But the knowledge
you're providing is extremely valuable.

=dman=

======================================
Start your formatting by formatting in this order from
most minor to the major total.
no levels, full page -- probably nothing to format
level 3 total -- select visible cells only, and format
level 2 total -- select visible cells only, and format
level 1 total -- select visible cells only, and format