Last week I wrote an article about hiding Excel macros, so they don't appear in the macro list. 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 [...]