TJ,

Sorry, there is no event that Excel can use to tell when you hide a row, so
once you've hidden the rows, you need to manually run the macro.

Bernie


"TJ" wrote in message
...
That is the effect I want. How can I make it so that when I hide the
cells
they are shaded without me having to run the macro every time I hide
cells?
I would like to have the act of hiding the cells trigger the shading.

"Bernie Deitrick" wrote:

TJ,

If they are hidden using hide rather than filters, then a macro like this
will shade the hidden rows:

Sub NewSub()
Application.ScreenUpdating = False
Cells.Interior.ColorIndex = 3
Cells.SpecialCells(xlCellTypeVisible).Interior.Col orIndex = xlNone
End Sub

HTH,
Bernie
MS Excel MVP


"TJ" wrote in message
...
How can I set up my worksheets so that rows that are hidden will be
shaded
in
if they are unhidden?