menumaker.xls
Excellent idea!!! I didn't know about that possibility, but I tested it and
it works... Thank you very very much.
Bruce
"JE McGimpsey" wrote in message
...
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
|