Runing a macro on Excel Startup

[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

 

[Bob Phillips]

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.

 

[Paul Taylor]

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

 

[Bob Phillips]

Paul,

Great, I'm glad it's sorted.

Regards

Bob