Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Macros before send? & Runtime error if choosing not to overwrite file? | Excel Programming | |||
Loading an xml | Excel Programming | |||
dynamically loading external macros, on the fly | Excel Programming | |||
Disable Macros when loading a Workbook in Excel 2000 | Excel Programming | |||
Macros loading under XL2003 | Excel Programming |