O'Reilly logo

Absolute Beginner's Guide to VBA by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required