Confused by tb_name and cb_name but tjis should help

Application.CommandBars.Add tb_name
Application.CommandBars(cb_name).Visible = True
With Application.CommandBars(cb_name).Controls.Add( _
Type:=msoControlButton, ID:=2950, Befo=1)
.OnAction="myMacro"
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"nath" wrote in message
...
Hi

I have written some code to create a custom command bar to
open a help file in a spreadsheet.

However, i can create the button, but i dont know how to
add the hyperlink to the button to get it to open the help
file, can ayone help?

Code is as follows:

Application.CommandBars.Add tb_name
Application.CommandBars(cb_name).Visible = True
Application.CommandBars(cb_name).Controls.Add
Type:=msoControlButton, ID:=2950, Befo=1

TIA

Nath