Activating a Macro by clicking a cell

[VidHuggers]

Hello,

So I have written a couple of macros that is sheet dependent where it extracts data from a row and puts it into a template sheet. My goal is to have the user be able to click on a certain cell, and it run the macro. I originally had a code that detected if a hyperlink was clicked, but to use ActiveCell, I had to hyperlink each cell to itself. Any way I could easily do this?

 

[davesexcel]

Checkout the Worksheet_SelectionChange event

 

[VidHuggers]

Sweet, figured it out, thanks.