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
Click to expand...
 
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.
 

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

Missing items in the menu bar 1
Progress bar in Excel 2010 0
Status Bar 6
how do you show the status bar if you accidently hide it? 2
Reading view 1
Create own tool bar Mac 2015 0
Scroll does not show preview 0
How to make scroll bar permanently visible, Word 365 0

Top