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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time to load spreadsheet | New Users to Excel | |||
Processing Overhead during Cut/Insert | Excel Programming | |||
Slow Add-in Load Time | Excel Programming | |||
Long time to load | Excel Programming | |||
SaveSetting/GetSetting: not high-overhead? | Excel Programming |