View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default problems adding botton to a menu bar

Hello, I created an add in with a userform, I want to create a button that
opens the userform when clicked, in order to doing so I have until now in my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro writen in
the add in does not appear in the macro dialog box.

thanks