Can you maintain full screen mode while in restore down.

[ApricityMech]

My Application is, on work book open. to be full screen but when I "restore down" the workbook goes back to the standard display with the ribbon and formula bar. This also happens when I minimize but is easily side stepped with

Private Sub Workbook_WindowResize(ByVal Wn As Window)

Application.DisplayFullScreen = True

End Sub

I simply want to maintain the full screen look while in restore down. And if I grab the title bar and SNAP the window my desired outcome does happen. If I click and drag the title bar I am able to resize the window while in full screen mode and excel is "aware" it is in restore down mode by right clicking the title bar and restore being grayed out and maximize being clickable. I just the outcome by clicking restore down or by having the restore down button invisible.

 

[ApricityMech]

I solved my issue.... I was using

Application.DisplayFullScreen = True

to enter full screen mode which has to maintain a full sized window.....

I should have (and am now using)

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"

which allows full screen mode appearance regardless of window size with the added benefit that it maintains full screen view regardless if esc is pressed.