Hi Ron

Rightclick the sheet tab. Choose "view code". Paste this in:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Beep
End Sub

Replace Beep with whatever you want done.

HTH. Best wishes Harald

"Ron_D" skrev i melding
...
I have a couple of Advance Filter tables where the criteria changes based
on
the current row. I would like a macro that will trigger whenever the
focus
changes to another cell.

Thanks in Advance,
Ron