Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Code Editor Slows execution speed
I have noticed lately that with some of my applications whenever I make a
change to code using the Code Editor the execution speed drops tremendously. If I save the very same changes, and then exit Excel altogether and then restart Excel, the speed of execution is normal. I have found one thread dealing with this issue at Subject: breakpoint affecting the run speed of a macro 12/1/2006. However, I do not see any response to that issue. Any ideas? Lon Sarnoff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Code Editor Slows execution speed
You might take a look at the link below. This might offer you an explanation
and a fix. Another way is to save all your modules to text files, delete the modules, then paste the code back in. That's really all this codecleaner does. It just does it real quick. This version has a monitor that backs code changes at save, which I find myself using more and more the older I get, lol. Regards, Alan http://www.appspro.com/Utilities/CodeCleaner.htm "Lon Sarnoff" wrote in message ... I have noticed lately that with some of my applications whenever I make a change to code using the Code Editor the execution speed drops tremendously. If I save the very same changes, and then exit Excel altogether and then restart Excel, the speed of execution is normal. I have found one thread dealing with this issue at Subject: breakpoint affecting the run speed of a macro 12/1/2006. However, I do not see any response to that issue. Any ideas? Lon Sarnoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Execution speed of VBA Code | Excel Programming | |||
Speed up Excel execution | Excel Programming | |||
code execution speed question | Excel Programming | |||
PrintPreview slows Code Execution | Excel Programming | |||
Execution speed for UDF | Excel Programming |