Can I make VB programs external?

[chuckm]

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

 

[Tom Ogilvy]

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-us/odeopg/html/deovrexceladdins.asp

http://msdn.microsoft.com/library/en-us/odeopg/html/deovrcreatingexceladdin.asp

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

 

[Chip Pearson]

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