Make text appear as button face

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Office 2003 and Windows XP;

How do I specify in VBA that a button should show its text rather than a
picture icon?

For examle, I have the following code:

With Application.CommandBars("Print Preview")
.Controls.Add Type:=msoControlButton
.Controls(14).Caption = "Options"
End With

But I want "Options" to appear on the face of the button...

Thanks much in advance.
 
XP said:
Using Office 2003 and Windows XP;

How do I specify in VBA that a button should show its text rather than a
picture icon?

For examle, I have the following code:

With Application.CommandBars("Print Preview")
.Controls.Add Type:=msoControlButton
.Controls(14).Caption = "Options"
End With

But I want "Options" to appear on the face of the button...
Click to expand...


Check VBA Help for the Style property of the
CommandBarButton object:
.Style = msoButtonCaption
 
Back
Top