How do I record a Macro that can be used on any spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It is the XLSTART folder (may be XLSTART10 or XLSTART11).

Since spreads in here are always loaded, your subs are available.
 
In the VBIDE immediate window use

?Application.StarupPath

to get the name of the directory.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I am taking a different tack on this question.

When you go to Tools>Macro>Record 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
 
Back
Top