How to run VBA on file open and close?

[bimmerman]

Afternoon everyone,

I've been searching for this but can't find anything to push me in the right direction so I'm asking for some help.

What I'm trying to do is figure out where to put VBA code that will run as soon as the file is opened even without having to hit a button or anything.

And then also if it's possible, where to put code that will execute as the file is closing as well.

Thanks for the help!

[VBA Noob]

These links should help

Code goes in ThisWorkbook

http://www.cpearson.com/excel/events.htm

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

[bimmerman]

Once again this site pulls through!

Thank you...

[VBA Noob]

Glad it helped

VBA Noob

[boylejob]

Bimmerman,

The document VBAnoob pointed you to is an excellant reference. Pay very close attention to the section call Order of Event Procedures.

I was recently helping someone create a log that tracked changes to a worksheet. We had put the code in the Workbook_BeforClose event, but were not capturing everything. Ended up we needed it in one of the events that were a little lower down on the list. This is particularly important if you have alerts turned off. The Pearson document proved to be invaluable in this situation.

Just thought I would throw that out there. It might help you someday!