Chapter 19. Adding Menus and Toolbars

Writing great code doesn’t do you much good if users can’t easily run it. In this chapter, I show you how to create menus and toolbars that run your code with a single click. These features are actually part of the Office object model, so the skills you learn here apply to Word, PowerPoint, and all of the other Office products.

This chapter includes task-oriented reference information for the following objects and their related collections: CommandBar, CommandBarButton, CommandBarComboBox, CommandBarControl, and CommandBarPopup.

Tip

Code used in this chapter and additional samples are available in ch19.xls.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.