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