Run Macro when I click on a cell

Hi,

New to this, but I have record a simple macro that run on keyboard press.

Is there any way to change it so that the macro will run when I click on eg. Cell A10

Also, I want the macro to select the whole of Column X and Y, but it seems to mess up and select other rows everytime.

Formula:

Sub FILTER_A_X_DELETEBLANK()

'

' FILTER_A_X_DELETEBLANK Macro

'

' Keyboard Shortcut: Ctrl+Shift+H

'

    ActiveCell.Offset(0, 5).Columns("A:B").EntireColumn.Select

    Selection.AutoFilter

    ActiveSheet.Range("$X$1:$Y$1003").AutoFilter Field:=1, Criteria1:="0"

    ActiveSheet.Range("$X$1:$Y$1003").AutoFilter Field:=2, Criteria1:="1"

End Sub

Thanks in advance!