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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[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)

"bill" <[email protected]> wrote in message
news:[email protected]...
> Yea, but when I create the new .xls from the .xlt all of the VBA code
> is included in the new .xls file.
>
> Bill
>