Hiding status bar in Excel 2007

J

Johnny J Woodhouse

How do I hide status bar in Excel 2007

I want to view full screen except for menu titles only
 
R

Ron de Bruin

As far as I know only with VBA.
After the beta it is removed

Application.DisplayStatusBar = False
 
J

Johnny J Woodhouse

Thanks - most helpful
Regards
JJ

Ron de Bruin said:
As far as I know only with VBA.
After the beta it is removed

Application.DisplayStatusBar = False
 
B

Bernard Liengme

One would expcet it to be in View | Show/Hide but it is not.

The only way I have found is with VBA:
Application.DisplayStatusBar = False

In the Excel Options on the Popula tab, check the Display Developer on
Ribbon
Now you can open Developer and clcik Visal Basic
Copy the cose above into the Immediate window; tap Enter key
Done!
Of course, Application.DisplayStatusBar = True will restore it.
 
Top