Select standard toolbar button option
Thank you.
I'll use it in this form. Don't need a dialog since I'll be doing it in
loops.
Thanks again.
--
Gary's Student
gsnu200710
"Jim Thomlinson" wrote:
Code like this...
Sub test()
Dim cbr As CommandBar
Dim ctl As CommandBarControl
Set cbr = Application.CommandBars("Standard")
Set ctl = cbr.Controls("Open")
ctl.Style = msoButtonIconAndCaption
End Sub
or did you want the customize dialog
--
HTH...
Jim Thomlinson
"Gary''s Student" wrote:
On the worksheet I can pull-down:
View Toolbars Customize
I can then right-click any of the standard toolbar buttons and select:
Image and Text
How can I do this with VBA?
--
Gary''s Student
gsnu200710
|