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