Load time overhead of VBA controls
 

The time taken to load my Excel 2000 workbooks increases by 30 sec for
each VBA control used. Run time is unaffected. I think this delay is
recent, does not depend on the size of VBA code and is increasing with
use of the workbooks. The computer is running Norton Antivirus and
appears to be virus-free. Office protection and macro security are
disabled. Has anyone any ideas why load time should be affected.

Load time overhead of VBA controls
 

I think controls graphics get written to the Temp folder. This might be the
overhead?

Whenever I see unexplained delays, I'll use RegMon and FileMon from
www.sysinternals.com
This usually gives me a clue as to whats causing delays.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


wrote in message
...
The time taken to load my Excel 2000 workbooks increases by 30 sec for
each VBA control used. Run time is unaffected. I think this delay is
recent, does not depend on the size of VBA code and is increasing with
use of the workbooks. The computer is running Norton Antivirus and
appears to be virus-free. Office protection and macro security are
disabled. Has anyone any ideas why load time should be affected.