menumaker.xls

  • Thread starter Thread starter Bruce Roberson
  • Start date Start date
B

Bruce Roberson

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
 
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.
 
Bruce,

Why not put it in an addin?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hey Bob:

Of course I've never done an addi-in, but if I did, wouldn't the menu
choices have to be the same for each workbook I used the add-in with?

Bruce
 
Excellent idea!!! I didn't know about that possibility, but I tested it and
it works... Thank you very very much.

Bruce
 
Bruce,

Well they don't have to be the same, but as any of them could delete the
menu I must admit that I had assumed they all were the same. If they are
not, then I don't understand why you have a problem as each workbook would
have it's own menu would it not, so each workbook would only remove its
own.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top