I have a medium size VBA app (14,000 lines of code, 27 worksheets, 15 forms, 9 modules, 25 classes) and would like to know what the heck Excel does before the workbook_open event. It takes its sweet time loading (18 seconds) and I'm curious what the overhead is and if there is something I can do about it. Do any of you experts know what's behind the scenes? (Same question applies to the haps after workbook_close event.)
Curious Deb <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>