template code in one place
 

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

template code in one place
 

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" wrote in message
oups.com...
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

template code in one place
 

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

Bill

template code in one place
 

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bill" wrote in message
oups.com...
Yea, but when I create the new .xls from the .xlt all of the VBA code
is included in the new .xls file.

Bill