Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time to load spreadsheet | New Users to Excel | |||
Load time overhead of VBA controls | Excel Programming | |||
Processing Overhead during Cut/Insert | Excel Programming | |||
Slow Add-in Load Time | Excel Programming | |||
SaveSetting/GetSetting: not high-overhead? | Excel Programming |