View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Clearing the status line

Hi John,
See if Ctrl+Alt+F9 will break it loose
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#calc
about screenfulls of material before the next topic.

For Excel 2002 there's a more supreme one Ctrl-Alt-Shift-F9.

Also check your tools, options, calculate, one more time.
Can you run other macros in other words make sure you are not in
pause mode in the VBE..

Do you have a LOT like thousands of cell dependent back to another
cell. If you do I think there is an MS KB article about that.-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John Tripp" <John wrote in message ...
VBA 2000 Excel Office Professional
How can I clear the status line? After I run subroutine the work
"Calculate" appears on the status line. I can't seem to clear it. I tried
F9. I also tried calculate as last command in macro. Thanks for any help