Excel 2010 open in full screen

P

pcor

Hi
What do I have to do to get EXCEL 2010 to open in FULL SCREEN.
I now save all my data while the screen is full and then shut it
down...bUT when I reopen EXCEL it is NEVER in full screen and I have
to adjust it every tiem
I would appreciate the help
Thanks
 
G

George

Hi pcor,

you can run this code:

Sub Macro1()
Application.DisplayFullScreen = True
End Sub

Please tell me does it work for you.
 
G

George

Hi pcor,

I'm sorry, my answer was not complete. You should add autorun macros
like this:

Sub Auto_open()
Application.DisplayFullScreen = True
End Sub
 

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

Top