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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

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,122,363
Messages
5,595,705
Members
414,013
Latest member
tnobbs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top