UsingCellSelectionToTriggerAMacr.xlsm

<div>
That's perfect Brad — and just what I was after. Thanks
</div>


That's perfect Brad — and just what I was after. Thanks

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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?<br />
<br />
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.<br />
<br />
What I'm wondering is if, instead of the above, a cell itself can be defined as the trigger for a macro <b><i>so the macro can be launched by clicking the cell</i></b> — in the same way an hyperlink can be activated by clicking the cell.<br />
<br />
Thanks
</div>
</div>


Hello,

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.

Thanks

Run an Excel macro by clicking a cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.