Start Excel in full screen Mode

[Colleen45]

This has probably been posted before, but I can't seem to find an answer, and it's driving me crazy.
Excel has stopped starting in full screen mode, what setting do I need to make to get Excel to start in full screen mode again?>

 

[Michael M]

Try

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Visible = False
End Sub

 

[Colleen45]

My thing is, I never had to put code in to get Excel to start in full screen mode, it doesn't seem right to do it now!!!
The code may force the issue, but there must be another reason why Excel does not start in full screen mode when it used to without code, this is the part that's driving me crazy

 

[Teeroy]

The full screen setting is application wide so should be retained when you've set it in the view tab. If any spreadsheet you have used changes the setting though then that change is retained.

 

[Colleen45]

I've tried that, but it does not retain the full screen mode when setting it to full screen, when you restart excel again it start in quarter size!!

 

[Teeroy]

Try the tip in Set Default Window Size - Windows 7 & 8 - Information Systems Knowledge Base.

There may be a bug in Office 2010 as described here.

 

[Colleen45]

I tried that this afternoon, sadly to no avail,
I've also tried the repair function, that never worked either.

I'm wondering if a uninstall, and reinstall might work. might be the answer.

However does anyone know where Microsoft keeps its files for the Quick Access tool bars, as I have a lot of icons added to the quick access toolbar. and the thought of manually replacing them one by one leaves me cold

 

[tcardwell]

Hi Colleen,

Were you ever able to solve the mystery of Excel not starting in full screen mode? I think I now have this problem!

Tom C