menumaker.xls
 

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

menumaker.xls
 

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

menumaker.xls
 

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)

"Bruce Roberson" wrote in message
...
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

menumaker.xls
 

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
"Bob Phillips" wrote in message
. ..
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)

"Bruce Roberson" wrote in message
...
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

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

menumaker.xls
 

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)

"Bruce Roberson" wrote in message
...
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
"Bob Phillips" wrote in message
. ..
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)

"Bruce Roberson" wrote in message
...
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