Size Of Screen

[Andrew Turek]

I have a worksheet which requires a screen of 1024 * 768. It has
ThisWorkbook_open macro which automatically sets Full Screen, but i
there any VBA code I could add to it which would reset the scree
size?

There is also a Quit macro which switches off Full Screen - is ther an
code which could reset the screen size?

And while I am on: is there any way I can set Excel so that the Formul
Bar is always visible when I start a session?

Thanks, one and all

 

[icestationzbra]

the formula bar can be toggled with:

Application.DisplayFormulaBar = False
Application.DisplayFormulaBar = True

put the 'true' part in workbook's open event

 

[icestationzbra]

if you are only talking about toggling the 'full screen', then you ca
create a sub procedure called auto_close() and put the following lin
in it:

Application.DisplayFullScreen = False

i do not know how to change the resolution back to whatever it wa
earlier

 

[Andrew Turek]

Thanks for these tips. What I meant about the Formula Bar is that I
would like it to be open by default when I launch Excel, which at the
moment it is not - any bright ideas?

 

[icestationzbra]

i can't understand you question, so my answer might sound kind o
basic.

the View menu has an option for toggling Formula Bar. it will ensur
that the formula bar is visible everytime you open excel

 

[Andrew Turek]

And I am a prat. Thanks for that - how could I miss it