How can run a macro ( call a macro) on selection of any filtercriteria?
Try the worksheet Change event, it goes into the worksheet module,
right click on the sheet tab and select View Code, Paste the code
there
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then YourMacro
End Sub
YourMacro will actually be the name of your macro, and will run when
you change A1
|