Perhaps these events may be of use?
Private Sub Workbook_AddinInstall()
MsgBox "Bill's Tools sucessfully installed", vbInformation, "Install OK"
End Sub
Private Sub Workbook_AddinUninstall()
MsgBox "Bill's Tools sucessfully un-installed", vbInformation,
"Un-install OK"
End Sub
Private Sub Workbook_Open()
CreateMenus
SetupEventHandler
End Sub
--
Regards,
Bill Lunney
www.billlunney.com
"Stratuser" wrote in message
...
I have created an add-in that I want to give some people
in the office. Also, I have created a little routine that
puts a toolbar button on the user's toolbar to activate
the add-in's macro. Is there a way to automatically
install a toolbar button when an add-in is attached (but
not yet used)?