Is it possible to write an if statement in VBA that will run a macro if a cell is selected. For example, if I simply selected cell H4 then I want Macro (x) to Run.

If that is possible then is it is possible to run a macro after hitting a hyperlink in my workbook. For example cell H4 contains an if formula that will create a hyperlin from sheet 1 to sheet 2 based on certain conditions. If those conditions are met could I then run a macro in sheet 2 by hiting the hyperlink