template code in one place

[bill]

All,

Is there any way to keep Excel template VBA code (workbook, forms,
modules and classes) in just one location? Like a MS Word .dot
template? So that when the user creates a .xls from the .xlt the
functionality is available, but the code is not actually located in the
newly created .xls.

TIA,

Bill

 

[Bob Phillips]

Yes, set it all up in a new file, and save that file as a template named
Book.xlt in the XLStart directory.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[bill]

Yea, but when I create the new .xls from the .xlt all of the VBA code
is included in the new .xls file.

Bill

 

[Bob Phillips]

So, just don't put any VBA in the template!

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)