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
|