Having trouble adding spacers to menus

  • Thread starter Thread starter Gary Lemmon
  • Start date Start date
G

Gary Lemmon

Normanly in a VB form I would add a dash to the caption of a menu item to
get a spacer between menu items. I can not find any docs or discover any
combination to add a space to the Office.CommandBarButton.caption when
building meues for the Office command bar.

Can any one help?

Thanks Gary
 
Solved my own problem. I found some useful information in an old MSDN
Set databaseItem = CommandBars("Worksheet Menu Bar").Controls("File") _
.Controls("Open Database")
databaseItem.BeginGroup = True

It is the BeginGroup attribute associated with the Command bar item that
sets the seperator.
 
Back
Top