Can I make VB programs external?
 

I have a workbook with 500k of VB. Is it possible to externalize the
VB code so that other workbooks can reference it and execute the
programs...without loading the VB?
thanks
chuckm

Can I make VB programs external?
 

Yes, put your code in an addin.

See Jan Karel Pieterse's tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/?id=211563
How to create an add-in file in Excel 2000

http://msdn.microsoft.com/library/en...xceladdins.asp

http://msdn.microsoft.com/library/en...exceladdin.asp

http://www.j-walk.com/ss/excel/tips/tip45.htm
Excel 97: Creating Add-Ins

--
Regards,
Tom Ogilvy

"chuckm" wrote in message
ups.com...
I have a workbook with 500k of VB. Is it possible to externalize the
VB code so that other workbooks can reference it and execute the
programs...without loading the VB?
thanks
chuckm

Can I make VB programs external?
 

No. The VBA code, whether in a file or add-in, must be loaded in
order to run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"chuckm" wrote in message
ups.com...
I have a workbook with 500k of VB. Is it possible to
externalize the
VB code so that other workbooks can reference it and execute
the
programs...without loading the VB?
thanks
chuckm