As an alternative, I'd suggest you create the menu for each workbook
using the Workbook_Activate event, then restore the menu using the
Workbook_Deactivate event.

That way you'll always have only the menu items you need for the active
workbook.


In article ,
"Bruce Roberson" wrote:

I use a variation of the Walkenbach menumaker menu system on many of my
workbooks. The problem is when two or more of these types of workbooks are
open. If one is then closed, the menu is removed and you have to go click a
button to add the menu back. Rather than click the button on each menu sheet
for a respective workbook, I would rather have a toolbar icon to click that
would add the menu back that was specific to the active workbook in this
case.

How can I set this up?

Thanks,


Bruce