Having trouble adding spacers to menus

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Lemmon - 01 Dec 2003 05:10 GMT

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

Reply to this Message

Gary Lemmon - 01 Dec 2003 20:58 GMT

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.

> 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
[quoted text clipped - 4 lines]
>
> Thanks Gary

Reply to this Message