I am taking a different tack on this question.

When you go to ToolsMacroRecord New Macro a dialog box will open to name the
macro.

Also where to store it.

Select "Personal Macro Workbook" to record to.

This will record the macro into Personal.xls which is stored by Excel in your
XLSTART folder.


Gord Dibben MS Excel MVP

On Fri, 2 Feb 2007 21:14:00 -0800, Eqa wrote:

I am unable find and open something called "Workbook start up folder" If I
record a macro in this does it allow me to use the macro for any future
spreadsheets with the same layout and headings?