Thread: custom menus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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