Automatic Setup of Custom Menu in Toolbar

[hailnorm]

I'm trying to create a custom menu in the toolbar. Since this menu is
local to my machine, I tried to record a macro that will reproduce it
for anyone using the file. But that didn't work. I got a ton of blank
menus & then a debug error.

Is there any way to "carry over" the custom menu to anyone using the
file instead of me having to manually setup the menu on each person's
machine?

 

[Gord Dibben]

hail

Instructions and code for creating/deleting custom menu items.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q166755&

Gord Dibben Excel MVP

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/MenuActiveWbDemo.zip
It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm

It contains VBA code that will activate a menu only when the workbook it is
in is active.

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[hailnorm]

Thanks. This is exactly what I needed