Save Status Bar Disappers after running macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top