Setting Up the Custom Menus

To activate the mock features of our add-in shell, we will create a custom menu. We will discuss the creation of menus and toolbars at length in Chapter 12. For now, we will keep the details to a minimum so we can get the overall picture of add-in creation.

Our custom menu should be created automatically when the add-in loads and destroyed when the add-in unloads. Accordingly, we begin by placing some code in the Open and BeforeClose events of ThisWorkbook, as shown in Example 10-1.

0 0

Post a comment