In VB Editor, double-click on the sheet you want so that you can view its code window.
Change selection in box on upper left of code window from (General) to Worksheet.
In the box at upper right of code window choose Selection Change.
In the subroutine, call your macro.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call myMacro
End Sub
Bookmarks