LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Autorun Add-in

I'll try it. Thanks.


"Chip Pearson" wrote in message
...
In the XLA's ThisWorkbook code module, put the code to build the menu:

Private Sub Workbook_Open()
' your code here
End Sub

Then, use BeforeClose to delete the menu:

Private Sub Workbook_BeforeClose(ByRef Cancel As Boolean)
' your code here
End Sub

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Fri, 11 Dec 2009 14:34:11 -0500, "Todd Heiks"
<Todd.Heiks_AT_NoSpam_GreatLakesWindow.com wrote:

How do i make my addin run when it is added to excel?
I want the user to browse to my addin and then have the addin build the
toolbar for itself.

Regards,
Todd



 
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
Autorun macro does not autorun... ARbitOUR[_19_] Excel Programming 5 August 24th 09 02:18 PM
AutoRun Usen Excel Programming 2 November 16th 07 09:22 PM
Autorun EmilH Excel Programming 6 June 5th 07 10:30 AM
Autorun.inf Pam Excel Programming 2 October 17th 05 06:56 PM
Autorun Add-In A.M Excel Programming 2 September 21st 04 04:19 PM


All times are GMT +1. The time now is 05:52 AM.

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

About Us

"It's about Microsoft Excel"