Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default Auto-install toolbar button with add-in

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)?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
restoring toolbar after re-install Mike Row Soft Setting up and Configuration of Excel 1 December 29th 09 10:16 PM
Tool to automatically install a macro + button on 200+ instances ofexcel? [email protected] Excel Worksheet Functions 0 January 30th 09 11:49 PM
toolbar button Dennis S. Excel Discussion (Misc queries) 5 July 9th 08 03:52 AM
Auto Filter Toolbar Button Does not Toggle Pastel Hughes Excel Discussion (Misc queries) 2 October 26th 06 09:25 PM
How do I take a toolbar created at home and install it at work? lhcook Excel Discussion (Misc queries) 2 May 4th 06 09:06 PM


All times are GMT +1. The time now is 01:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"