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

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