Chapter 14. Creating Custom Menus and Toolbars

     

Chapter 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 , having to access the Visual Basic Editor.

To help you avoid these problems, this chapter presents some techniques for making your macros more accessible. To wit, I'll show you how to give your users the ability to use familiar tools ”namely, menus and toolbars ”to run your macros. You'll learn not only how to modify menus and toolbars by hand using the built-in application tools, but also how to build custom menus and toolbars using VBA code.