Load time overhead of VBA controls

C

chestersjk

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.
 
R

Rob van Gelder

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top