Run an Excel Macro From a Cell Reference

Last week I wrote an article about hiding Excel macros, so they don’t appear in the macro list.

Collapse Dialog Button

While working on that article I noticed that the Macro dialog box has a Collapse Dialog button.

While the Macro name box is active, you can go to the workbook, select a sheet, and click on a cell.

Macro dialog box has a Collapse Dialog button
Macro dialog box has a Collapse Dialog button

Confusing Button

I couldn’t figure out why that button was there.

Even if I typed a macro name in a cell, then clicked on that cell, that macro didn’t run.

Refer to Macro Sheets

Dave Peterson suggested that the Collapse Dialog button might be related to Excel’s old style XLM macros.

And he was right – I finally found the confirmation in my old Excel 3.0 manual.

  • It says “You can also enter in the Reference box the reference of the first cell of the command macro you want to run.”

The old style macros were written on Macro sheets.

Old Excel Macro Sheets
Old Excel Macro Sheets

Starting Cell on Macro Sheet

From the Macro dialog box, you could click on the starting cell of a macro, then click the Run button.

Starting Cell on Macro Sheet
Starting Cell on Macro Sheet

Compatibility Reasons?

I guess the button is still there for compatibility with those old XLM macros. Maybe the button will eventually disappear from the Macro dialog box.

___________________

0 thoughts on “Run an Excel Macro From a Cell Reference”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.