There's a Workbook_Open event that you can put in the ThisWorkbook module.
There's also UserForm_Activate and UserForm_Initialize if you're using a
UserForm - I'm not sure yet. Let us know.
Here's a reference:
http://www.mrexcel.com/archive2/6800/7624.htm