Macro not with a file

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
Back
Top