Runing a macro on Excel Startup

  • Thread starter Thread starter Paul Taylor
  • Start date Start date
P

Paul Taylor

Is there a way to have a macro automatically run, whenever
excel starts (be from the start menu, already existing
files or whatever).

My default file location is permanently set by my IT folks
and I'd like to change the location.

Thanks,
Paul
 
Create a Worksheet_Open event code macro, in ThisWorkbook code module, in an
empty workbook, and save this workbook as Personal.xls in the XLStart
directory.
 
Thanks for the reply Bob. I had actually tried something
like this already (I think). Since I already have a
Personal.xls workbook, I added a module with a macro
called "private sub Workbook_Open" (based on an article
from MS knowledge base). I put a msgbox in it so I would
know if it ran, and it didn't, so I'm wondering if it is
because I'm using Excel 97? Or perhaps the combo of
Win2000 and Excel 97

Any clues?

Thanks,
Paul
 
Back
Top