Unhide part of Full Screen button

R

Roger Bedford

When I use the Full Screen button in Excel 2002 it hides the menu row that
contains the cell reference and the fx box which shows the data selected or
being entered. Is there any way to keep this row showing when I am in Full
Screen?

Any help would be greatfully appreciated.

Roger
 
N

Nigel

Try this, the formula bar is hidden by DisplayFullScreen, but after you run
this the bar will always show.

Application.DisplayFormulaBar = True

Cheers
Nigel
 

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

form buttons on sheet collapse on unhide - sometimes 5
VB to get to top of page 2
Unhiding rows 3
Toggle for Macro 5
This should be so simple but it's not working, please help 4
Hide Command button on close 1
Question on Hide/Unhide cells 4
Hide/Unhide cells using VBA programming 3

Top