Excel 2010 Status Bar disappeared

[Kappy]

From time to time, the status bar in excel 2010 is not showing (I don't mean the information is not showing, I mean the bar is not there at all). In previous versions I would go to view>status bar...

how do I get the status bar back in excel 2010?

Thanks!

 

[RoryA]

There isn't a way to turn that on and off except through code, unless you are switching to full screen mode?

 

[Kappy]

Thanks... there's a macro in the workbook which must be turning off the status bar.. No big deal, but so silly that they would go out of their way to remove that option

Thanks again

 

[RoryA]

Turning it off can speed up processing, but it should be turned back on at the end!

 

[HRR]

So, how do I turn it back on? It only seems to be happening in one xls file.

Thanks!

 

[RoryA]

application.DisplayStatusBar = True

 

[Northway]

That's great. How do you apply the code?

 

[Greg Truby]

That's great. How do you apply the code?

For just a one-of?

• Alt+F11 to open the Visual Basic Editor.
• Ctrl+G to open the immediate window.
• Copy & paste Rory's command and then hit ENTER.

Your statusbar should reappear.

 

[Northway]

Thanks, but it didn't work. I would prefer to have it off all the time so my charts would be taller.

 

[RoryA]

that code is to show it, not hide it.