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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Status Bar more complex 1
Custom Message in Status bar 1
Status Bar shows "Calculate", but calculation is set to Automatic 1
Why doesn't status bar update consistently? 16
Status Bar Hangover 3
Status Bar 1
Variable Type and Speed in Updateing Status Bar 4
Status Bar does not display in Excel 7.0 5

Back
Top