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