Status Bar in Excel does not display "calculate"

[Wknwrkr]

For some reason my status bar does not indicate when I need to "Ready" nor "Calculate". My setting is on manual calculation. I have very intricate spreadsheets with several tabs and it very frustrating when I have to calculate because it does not indicate when the calculations are complete. Sometime I end of freezing the process because I start working on the spreadsheet again before its finished calculating. Any ideas how to make the messages appear? I tried everything I can think of.

 

[GlennUK]

Have you run any macros that use the status bar? It may be that any such macros did not reset the status bar before completion.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Gavona]

If you have run a macro that uses the status bar then it could have not reset things properly. This is an example from Excel help of how it should be done. A one-line macro including the bold line should reset things for you.

I think it also resets if you quit and re-load Excel.

oldStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Please be patient..."
Workbooks.Open filename:="LARGE.XLS"
[b]Application.StatusBar = False[/b]
Application.DisplayStatusBar = oldStatusBar

(NB macro related follow up questions belong in Forum707)

Gavin