Microsoft KB Archive/94187

{|
 * width="100%"|

Excel: Macro Recorder Does Not Use Custom Macro Sheet

 * }

-

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.

Microsoft Excel for Windows
In version 4.0 of Microsoft Excel for Windows, you can customize the default macro sheet by naming a template &quot;MACRO.XLT&quot; (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 &quot;MACRO&quot; (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.