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
 

You may want to try cleaning up your windows Temp folder.

Close excel (and any thing else running--just to be safe)
windows start button|run
%temp%

and delete all the files/folders you can.

Then test it to see if that helps.

wrote:

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.

--

Dave Peterson