Thanks very much for great help, David and others here.
I will be reading through this material this weekend. It was
a rather hellish week in the stock market, in case you didn't
notice -- so it has taken me a bit of time to get back to this.
But I did much appreciate the input.

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

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