Thread: Command Bars
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nath nath is offline
external usenet poster
 
Posts: 57
Default Command Bars

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