Thread: Custom Menus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Wiggins[_2_] Andy Wiggins[_2_] is offline
external usenet poster
 
Posts: 11
Default Custom Menus

This file might be a help:
http://www.bygsoftware.com/examples/...tiveWbDemo.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"


"Lew Jones" wrote in message
...
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?