Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Loading Macros at Runtime

HI - In the past few weeks I have written a pile of VB Macro code including
new toolbar buttons with underlying menues and submenues. The problem is I
cant figure out how to ensure that the new buttons and menues, and their
associated macro code, is always loaded whenever excel is run? Some of the
macro code is Class code and some is at the general module level. Your help
is greatly appreciated.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Loading Macros at Runtime

Put it in an add-in.


http://support.microsoft.com/default.aspx?kbid=179008
MacXL: How to Create an Add-in File in Microsoft Excel


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<RjS; <CISSP; "CISA" wrote in
message ...
HI - In the past few weeks I have written a pile of VB Macro code

including
new toolbar buttons with underlying menues and submenues. The problem is I
cant figure out how to ensure that the new buttons and menues, and their
associated macro code, is always loaded whenever excel is run? Some of the
macro code is Class code and some is at the general module level. Your

help
is greatly appreciated.

Thanks



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
Remove Macros before send? & Runtime error if choosing not to overwrite file? nbaj2k[_30_] Excel Programming 17 August 11th 06 11:42 AM
Loading an xml Mike Archer Excel Programming 3 May 16th 06 07:21 AM
dynamically loading external macros, on the fly sp00nix[_25_] Excel Programming 2 March 19th 06 12:45 AM
Disable Macros when loading a Workbook in Excel 2000 Remy[_3_] Excel Programming 4 December 16th 05 08:07 PM
Macros loading under XL2003 S G Booth Excel Programming 2 March 4th 05 06:06 AM


All times are GMT +1. The time now is 12:35 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"