Microsoft KB Archive/109417: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 14: | Line 14: | ||
In Microsoft Excel version 5.0 it is not possible to replace the default Visual Basic module with an autotemplate called MODULE.XLT. It is possible to replace all of the other types of sheets (worksheets, chart sheets, dialog sheets, and Microsoft Excel 4.0 macro sheets) with autotemplates. | In Microsoft Excel version 5.0 it is not possible to replace the default Visual Basic module with an autotemplate called MODULE.XLT. It is possible to replace all of the other types of sheets (worksheets, chart sheets, dialog sheets, and Microsoft Excel 4.0 macro sheets) with autotemplates. | ||
If you save an autotemplate called MODULE.XLT to the EXCEL\XLSTART directory, the word | If you save an autotemplate called MODULE.XLT to the EXCEL\XLSTART directory, the word "Module" will appear twice in the Insert dialog box. | ||
== MORE INFORMATION == | == MORE INFORMATION == | ||
Line 36: | Line 36: | ||
Dialog Dialog | Dialog Dialog | ||
</pre> | </pre> | ||
Saving the MODULE.XLT autotemplate does not replace the | Saving the MODULE.XLT autotemplate does not replace the "Module" item in either of the following locations: | ||
<ul> | <ul> | ||
Line 43: | Line 43: | ||
<li>The Insert dialog box (choose Insert from the shortcut menu).</li></ul> | <li>The Insert dialog box (choose Insert from the shortcut menu).</li></ul> | ||
In the Insert dialog box, the word | In the Insert dialog box, the word "Module" will appear twice. The first Module is the default Visual Basic module. The second Module is the autotemplate file MODULE.XLT, which contains your custom settings. | ||
For this reason, it is recommended that you save your Visual Basic autotemplate with a name other than MODULE.XLT. Names you might want to use include MYMODULE.XLT or CUSTOMVB.XLT. Using a different filename will help you distinguish between your autotemplate and the default module template. | For this reason, it is recommended that you save your Visual Basic autotemplate with a name other than MODULE.XLT. Names you might want to use include MYMODULE.XLT or CUSTOMVB.XLT. Using a different filename will help you distinguish between your autotemplate and the default module template. | ||
Line 59: | Line 59: | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED | THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. | ||
</blockquote> | </blockquote> | ||
<span>Last reviewed: September 12, 1996</span><br /> | <span>Last reviewed: September 12, 1996</span><br /> | ||
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | [[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | ||
|} | |} |
Latest revision as of 10:33, 20 July 2020
Microsoft Knowledge Base
XL5: Cannot Replace Default Module with Autotemplate
Last reviewed: September 12, 1996
Article ID: Q109417
The information in this article applies to:
- Microsoft Excel for Windows, versions 5.0, 5.0c - Microsoft Excel for the Macintosh, versions 5.0, 5.0a
SUMMARY
In Microsoft Excel version 5.0 it is not possible to replace the default Visual Basic module with an autotemplate called MODULE.XLT. It is possible to replace all of the other types of sheets (worksheets, chart sheets, dialog sheets, and Microsoft Excel 4.0 macro sheets) with autotemplates.
If you save an autotemplate called MODULE.XLT to the EXCEL\XLSTART directory, the word "Module" will appear twice in the Insert dialog box.
MORE INFORMATION
Microsoft Excel version 5.0 allows you to create a special type of file called an autotemplate. Autotemplates are template files that have been saved into the EXCEL\XLSTART directory with the following names:
Worksheet SHEET.XLT Chart CHART.XLT MS Excel 4.0 Macro MACRO.XLT Module MODULE.XLT Dialog DIALOG.XLT In Microsoft Excel for the Macintosh, the files are saved into the 'System Folder:Preferences:Excel Startup Folder (5)' folder with the following names: Worksheet Worksheet Chart Chart MS Excel 4.0 Macro Macro Module Module Dialog Dialog
Saving the MODULE.XLT autotemplate does not replace the "Module" item in either of the following locations:
- The Macro submenu on the Insert menu. -or-
- The Insert dialog box (choose Insert from the shortcut menu).
In the Insert dialog box, the word "Module" will appear twice. The first Module is the default Visual Basic module. The second Module is the autotemplate file MODULE.XLT, which contains your custom settings.
For this reason, it is recommended that you save your Visual Basic autotemplate with a name other than MODULE.XLT. Names you might want to use include MYMODULE.XLT or CUSTOMVB.XLT. Using a different filename will help you distinguish between your autotemplate and the default module template.
KBCategory: kbusage Last reviewed: September 12, 1996 |