Menu Programming That Works with Events

Suppose that you want to create a menu when a workbook opens. You'll also want to delete the menu when the workbook closes because menu modifications remain in effect between Excel sessions. Or suppose that you want a menu to be available only when a particular workbook or worksheet is active. These sorts of things are relatively easy to program, thanks to Excel's event handlers.

The examples in this section demonstrate various menu-programming techniques used in conjunction with events.

I discuss event programming in depth in Chapter 19.

0 0

Post a comment