View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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