Ok, I'll bite. Why not use the auto_open or workbook_open events?

Use Auto_Open procedure *instead* of Workbook_Open event is what I
suggested. Auto_Open (and Auto_Close) are AutoMacros that will run
independant of events. So if for any reason events are disabled when
your file is opened (or closed), your AutoMacros will run.

Also, if your project becomes corrupt the events for ThisWorkbook may
not even work!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion