tool tips & custom buttons

  • Thread starter Thread starter daniel
  • Start date Start date
D

daniel

what is the code to change the tool tip for the button in this example:
Private Sub AddToolbar()
Dim tbb As Object
On Error Resume Next
Toolbars("Test").Delete
On Error GoTo 0
Set oTB = Toolbars.Add(Name:="Test")
With oTB
.Left = 117
.Top = 186
Set tbb = .ToolbarButtons.Add(Button:=23, Before:=1)
tbb.OnAction = ThisWorkbook.Name + "!custommacro"
.Width = 200
.Visible = True
End With
End Sub

question 2
can you create/design a custom button in excel 2007?
if so, how?
 
You should use CommandBars and CommandBarControls rather than
Toolbars. Toolbars are obsolete.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tool tip 1
change a tool tip 4
Toolbar Not Creation Problem 1
One more time (I hope) 3
Subscript out of range error? 3
Reset Custom Button on toolbar 1
Creating toolbar macro errors 2
The same event handler for two CommandBar buttons 6

Back
Top