Is there a way to enable a macro by double-clicking a cell?
Currently, I'm running an AutoFilter macro that
automatically references a second sheet when the specific cell is selected. The problem is that when a user does a search for
an item (Ctrl+F), the macro will immediately initiate and refer to the other cell which confuses the user.
Ideally, I want the macro to be initiated ONLY when the user DOUBLE-CLICKS on the cell.
Here's the code that
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Row