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

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dallman Ross" <dman@localhost. wrote in message ...
Thanks, Dave. In any case, I can simply my request drastically:

Can someone show me some sample event code to change a row's color
if the row above it moves from hidden to visible?

I think, all-in-all, that's pretty much all I'd need to do what
I want here.

--
dman

In , David McRitchie
spake thusly:

Unfortunately Ctrl+A does not always select the
entire worksheet starting with Excel 2003 and
botches up a shortcut that is so cross application.
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar