Excel: Macro Recorder Does Not Use Custom Macro Sheet

ID: Q94187

The information in this article applies to:

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

Additional query words: record template default 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 30, 1999