A number of years ago I wrote a database update program using Excel 2000. The program contains numerous relatively short macros each of which runs anywhere from 2 to 30 seconds. We have used the program several times a week for all these years with no problems. About 3 weeks ago, I showed a friend the basics of debugging a macro (step into, step through, setting breakpoints..) using this program. Shortly thereafter we noticed the macros (all macros in the workbook) were running much slower than before. We have older copies of this program and they still run at the rapid speed. We tried copying all instructions in the macro from the older rapid running program and pasted them into the corresponding macro in the slower running program. The macro then ran at the slower speed. Could I have inadvertently done something in the debugging process that made the macros run more slowly? Any help would be appreciated!
Bookmarks