You don't <g.

If you are asking how you get a macro to apply to all workbooks and not just
a particular workbook, you put the macro in a workbook in the XLSTART
folder. It will open automatically when you start Excel. Most people use the
Personal Macro Workbook for this purpose, which is a hidden workbook called
"personal.xls" in the XLSTART folder.

--

Vasant


"Mark" wrote in message
...
How do you make a macro reside in Excel and not in a file?