What it does
Shows an auto-complete search form that can be used to find and run any macro in the add-in, including custom macros and macros in the active workbook. Lets you set/unset keyboard shortcuts and define favorite macros.  For macro names suggested, displays category/menu, description, help URL, and other details.

When to use it
When you want to search for a macro to run or set/unset a keyboard shortcut.

Why to use it
This makes it very quick to run macros, as an alternative to the XLEV8 ribbon, and gives you an easy way to set/unset keyboard shortcuts – another way to run macros very quickly.

Default shortcut
Ctrl+Shift+W

Other Details

• Category: Productivity / Other
• Difficulty: 2/5
• Usage/frequency: 5/5
• Automation factor: 3/5 (estimated 10 seconds saved each time used)
• Type: Shortcut
• Date added: 1/4/2018
• Tags: search, auto complete, macros, shortcut

Related Macros
None

Other Articles
None

None

Prerequisites
None

Instructions

Run the Search Macros macro.  It will prompt you with a search form offering you suggestions of macro names as you type.  Use the up and down arrows (or click with the mouse) to select a suggested macro and insert the entire macro name in the search box.  When the entire macro name is in the search box, press the Enter key to run the macro.  When the entire macro name is in the search box, details of the macro are displayed – the keyboard shortcut (if any), category, description, and other details.  The help URL is also displayed.

Press the Escape key to clear the search box.  If the search box is empty when you press the Escape key, the search box will close.  You can also clear the search box by pressing the X icon to the right of the search box.

There are four other icons to the right of the search box – three of them will sort the search results either ascending, descending, or in the order they were originally displayed.  The far-right icon will toggle the search box to display all macros or only favorite macros.

If the active workbook contains macros, you can optionally include them with the search results.  Just click the checkbox to the right of the search box (it will be saved for future use), then simply type part of the macro name in the search box.

With the entire macro name in the search box, you can also:

• Set/unset keyboard shortcuts – enter a lower-case or upper-case letter in the shortcut box, then press Set to set the keyboard shortcut.  When the letter displayed, press Unset to unset the keyboard shortcut.
• Set/unset as a favorite macro – simply check the box to favorite it or uncheck the box to unfavorite it.
• Go to the support page – simply click the ? icon at the lower-right corner (or copy and paste the help URL to your browser address bar).