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.
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.
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.
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.
___________________
I think it will be there forever. Just like DATEDIF.