cg

See one answer to your earlier posting.

Gord Dibben Excel MVP

On Fri, 08 Oct 2004 18:51:57 GMT, "Terry V" wrote:


"Terry V" wrote in message
...
In the workbook, you can customize the toolbar and add a menu option that
drops down, just like the file menu etc.

Right click the toolbar, choose customize, choose New Menu from the
commands
tab, drag the "new menu" (on the right side) to the menu bar. From there,
Select macro from the Commands tab and Drag the "Customer Menu Item" to
the New Menu and hold it there for
a moment. It will drop down a small square where you can drop the
Customer
Menu Item into it.
Click on "Custom Menu" on the toolbar and you will see the Custom Menu
item
pop up below it. Click on it once and notice the "Modify Selection"
button
shows up in the Customize box. Click on it and select "Assign Macro". A
list of macros will show up and you can simply assign it to the button.
Then you can click where it says "Name" and name it whatever you want.
Do this for each macro you want in your menu (Just add more Custom Menu
Items and assign macros to each).

HTH
Terry V
"cghall55" wrote in message
...
Anyone know where I can get some code or directions for setting up a
personal
menu of macros? What I am trying to accomplish is that when a user opens
this
workbook the code kicks in and creates a menu with a few options on it.