custom menus
 

Monica,

Here is a re-post of a previous reply on this.

You could either build the toolbar when the workbook opens and destroy at
close, or attach it to the workbook. Do this by going to the View menu,
choose Tool Bars, then Customize. In that dialog, select the Toolbars tab
and click Attach. Select your command bar in the left side list box and
click Attach.


--

HTH

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

"Monica" wrote in message
...
I created several macros then a custom menu with options to trigger
them...three top level choices, each with 3 or 4 actions. I also set the
Open event to hide the Standard and Formatting toolbars then display the
custom menu. Problem is, when I email it to my client, the menu is not
found...apparently the menu is stored in Excel, not the workbook like the
macros.

thanks for any help,
Monica

custom menus
 

It is also possible to create menus with vba code. If you are comforable with this, you can look in 'excel 2000 vba'. I got a good template from there. It is a nuissance to set it up the first time, but editing the menus becomes very simple once you get going. You can define shortcuts, and have submenues, and menu breaks too

custom menus
 

Which is what this sentence means ...

You could either build the toolbar when the workbook opens and destroy at
close

--

HTH

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

"emg178" wrote in message
...
It is also possible to create menus with vba code. If you are comforable
with this, you can look in 'excel 2000 vba'. I got a good template from
there. It is a nuissance to set it up the first time, but editing the menus
becomes very simple once you get going. You can define shortcuts, and have
submenues, and menu breaks too.

custom menus
 

Bob,
you da' man...I had no clue that simple feature was there...thanks ever so

MKM