Run an Excel macro by clicking a cell
Posted on 2014-01-07
In Excel (2013), is there a way to trigger a macro by clicking a cell rather than by using a key combination or clicking an object or image?
As far as I know, Excel macros can be initiated only by a key combination (hotkey) or by defining an object (or image) as the trigger.
What I'm wondering is if, instead of the above, a cell itself can be defined as the trigger for a macro so the macro can be launched by clicking the cell — in the same way an hyperlink can be activated by clicking the cell.