Can you maintain full screen mode while in restore down.

ApricityMech

New Member
Joined
Oct 7, 2020
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

ApricityMech

New Member
Joined
Oct 7, 2020
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,075
Messages
5,570,054
Members
412,308
Latest member
essobsan
Top