Adding custom menu bar 2

[gdev]

Hi,

I am creating a custom menu bar with several popup menus. Do I need to
specify that it is a menu bar? Or does it matter?

For example,

Dim cbr As Commandbar
cbrPopup as CommandBarPop
Dim strname As string

strname = "My menu"

Set cbr = Commandbars.Add(name:=strname, position:=msoBarTop)
cbr.type = msoBarTypeMenuBar


thanks
gwen

 

[Dreamboat]

You'll love Chip's site, Gwen:

http://www.cpearson.com/excel/menus.htm#vba

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com