Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Color of control buttons

Status
Not open for further replies.

aMember

Programmer
Jun 12, 2002
99
US

I've got a custom toolbar that I need to stand out. The toolbar needs to be docked and was created using the code below. Is there any way to change the color of the font on the buttons or the background or font size...anything to make any part of the toolbar stand out. Using excel 97.

Thanks in advance.
-A-

Set TBar = CommandBars.Add
With TBar
.Name = "PRT Path"
.Position = msoBarBottom
.Left = 100
.Visible = True
'.Protection=
End With
Set NewCB = CommandBars("PRT Path").Controls.Add(Type:=msoControlButton)
With NewCB
.Caption = "Do Stuff"
.Visible = True
.OnAction = "DoStuff"
.Style = msoButtonCaption
End With
 
hey, aMember,

wysiwyg!

There is no color property for a commandbar Skip,
SkipAndMary1017@mindspring.com
 
What about the command buttons on the toolbar? Any way to change font or color on those?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top