In testing the 2007 version of Excel, I'm running into quite a bit of trouble with performance as it relates to executing VBA code. On numerous lines of code that didn't give any trouble in 2003, we're seeing a small timer bar appear with the caption "Cell (Press ESC to Cancel)" -- using the ClearContents method of a Range class, for example. Each time this happens, it takes anywhere from 5-60 seconds to execute that line. In the past version, our functions took a split second to run, but now they take several minutes because of all the timer bars that pop up. Is there a way to disable this timer bar or is this a new "feature" in Excel that we'll have to live with? Any help would be appreciated!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
"Press ESC to Cancel" in Excel 2007
- Thread starter cgraeter
- Start date
Similar threads
- Locked
- Question
- Locked
- Question