Absolute Beginner's Guide to VBA

14. Creating Custom Menus and Toolbars

In This Chapter

• Creating custom menus and submenus

• Adding menu commands for your macros

• Creating custom toolbars

• Adding toolbar buttons for your macros

• Manipulating menus, commands, toolbars, and buttons using VBA code.

In Chapter 1, “Recording Your First Macro,” and Chapter 2, “Creating Your Own Macros,” I showed you a number of methods for running your VBA macros. However, all these methods assume that you know which task each macro performs. If you're constructing procedures for others to wield, they might not be so familiar with what each macro name represents. Not only that, but you might not want novice users scrolling through a long list of procedures in the Macro dialog box or, even worse, ...