CustomMenu.Controls.Add
 

I have been using the CustomMenu for a while, but what I want to do is have
one menu option have multiple menu options "built" off it. For example, when
I trace down the File Menu to Print Area, I have an arrow for additional
choices, Set Print area and clear print area. I want to build these types
of additional choices. What is the syntax for this?

CustomMenu.Controls.Add
 

Add a pop-up control (which is what a menu is), and to this add your command
buttons.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mike H." wrote in message
...
I have been using the CustomMenu for a while, but what I want to do is have
one menu option have multiple menu options "built" off it. For example,
when
I trace down the File Menu to Print Area, I have an arrow for additional
choices, Set Print area and clear print area. I want to build these
types
of additional choices. What is the syntax for this?

CustomMenu.Controls.Add
 

The first example on this page shows the code to do this:

http://peltiertech.com/Excel/menus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
Add a pop-up control (which is what a menu is), and to this add your
command buttons.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mike H." wrote in message
...
I have been using the CustomMenu for a while, but what I want to do is
have
one menu option have multiple menu options "built" off it. For example,
when
I trace down the File Menu to Print Area, I have an arrow for additional
choices, Set Print area and clear print area. I want to build these
types
of additional choices. What is the syntax for this?