| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programmatically adding a break in a menu bar
Hey guys--does anyone know the code for adding a break into a menu bar?
I can do it with the Microsoft interface, but I don't know how to code one in and now need to. THanks, Abe |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
programmatically adding a break in a menu bar
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
programmatically adding a break in a menu bar
When adding the control, set BeginGroup to True
With .Controls.Add(Type:=msoControlButton) .BeginGroup = True .caption = ".... -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... Hey guys--does anyone know the code for adding a break into a menu bar? I can do it with the Microsoft interface, but I don't know how to code one in and now need to. THanks, Abe |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
programmatically adding a break in a menu bar
works great. Thanks!
Bob Phillips wrote: When adding the control, set BeginGroup to True With .Controls.Add(Type:=msoControlButton) .BeginGroup = True .caption = ".... -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... Hey guys--does anyone know the code for adding a break into a menu bar? I can do it with the Microsoft interface, but I don't know how to code one in and now need to. THanks, Abe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling VBE Break on All Errors Programmatically with DAO SetOpt | Excel Programming | |||
| Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
| Adding to AutoComplete programmatically | Excel Programming | |||
| Adding comment programmatically | Excel Programming | |||
| How to Programmatically Insert a Page Break Every Nth Row in a Range | Excel Programming | |||
Linear Mode
