Custom Menus

[Lew Jones]

Is it possible to programmatically add new items to a
custom menu? I've found many ways to add items to builtin
menus finding them by their ID, but custom menus don't
seem to have an ID, or do they?

 

[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"