Save Status Bar Disappers after running macro

[Guest]

Wheneve I build status bars into my spreadsheets, I find that Excels saving
status bar (blue bars at bottom left corner of sheet) disappears. When I say
status bars I mean of the type:

Application.StatusBar = "What is happening!!!!"

Why does this happen. How do I get it back without closing down and opening
back up again?

Thanks

EM

 

[Dave Peterson]

Make sure you give control of the statusbar back to excel:
application.statusbar = false
Right before you code ends (or where you want it)

If you've interrupted your macro (while testing???), you can go to the immediate
window and just type that command and hit enter to reset the statusbar.