| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best way to place text data into a formated Template? | Excel Discussion (Misc queries) | |||
| I want to place a calendar template on my desktop. | Excel Worksheet Functions | |||
| Where to place code that changes a cell value? | Excel Programming | |||
| where do i place the code ? | Excel Programming | |||
| Wherre best to place code | New Users to Excel | |||
Hybrid Mode
