View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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