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

Use Application.StatusBar = ""

"John Tripp" wrote:

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

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

Hi John,

In addition to David's suggestions, it is posssible that your sub turns off
automatic calculation. So, at the bottom of your sub insert the line:

Application.Calculation = xlCalculationAutomatic

---
Regards,
Norman



"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

Good point, and it also reminded me to look on my status bar page where I found
the link the MS KB article about calculate.
http://www.mvps.org/dmcritchie/excel/statusbar.htm

The Calculate message may remain in the status bar when you enter formulas that include cell references
"This behavior occurs when there are 65,536 or more dependencies to unique references (the level or number of links between
formulas). "
http://support.microsoft.com/default.aspx?scid=243495

I hope John provides feedback whether he finds a solution or not.
---
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



"bigwheel" wrote ..
Use Application.StatusBar = ""

"John Tripp" wrote:

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

Thanks to Bigwheel, David and Norman. All good suggestions. However, It
appears my problem was actually very different. When I tried to open my
spreadsheet, I could not open it at all in 2000. In 2002, I was able to open
it, but I could no longer run the macro successfully. I am going to continue
to investigate. In the meantime, I went back to a previous version and
implemented the changes. Everything appears to work fine.

David, thanks for the references. I plan to read them for my future use.

John Tripp