Excel: Macro Recorder Does Not Use Custom Macro Sheet

 Last reviewed: November 30, 1994
Article ID: Q94187
The information in this article applies to:
  • Microsoft Excel for the Macintosh, version 4.0
  • Microsoft Excel for Windows, version 4.0

SUMMARY

In version 4.0 of Microsoft Excel, you can replace the default macro sheet with your own custom macro sheet. However, Microsoft Excel does not use this new custom macro sheet when you record a macro with the macro recorder.

MORE INFORMATION

Customizing the Default Macro Sheet

Microsoft Excel for Windows

In version 4.0 of Microsoft Excel for Windows, you can customize the default macro sheet by naming a template "MACRO.XLT" (without the quotation marks) and placing this template in the XLSTART directory. If MACRO.XLT is in the XLSTART directory, all new macro sheets will be created based on this template. To use this new template, chose New from the File menu and select the Macro Sheet option.

Microsoft Excel for the Macintosh

In version 4.0 of Microsoft Excel for the Macintosh , to customize the default macro sheet, name the custom file "MACRO" (without the quotation marks), and place it in your Excel Startup Folder (4).

In both the Macintosh and Windows platforms, when you first use the macro recorder to record your macro your new template will not be used. When you use the macro recorder, Microsoft Excel creates a new macro sheet with the original template settings.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, Pages 79-83

KBCategory: kbother
KBSubcategory:

Additional reference words: 4.00 4.0 record template default

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.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.