Having trouble adding spacers to menus

[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

 

[Gary Lemmon]

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.