How to prevent a window from closing full screen

Cingetor

New Member
Joined
Apr 25, 2017
Messages
15
I know this has been posted before and I found some of the answers but none of them worked in my situation. I'm hoping someone has ran into this before and knows what to do. I have an excel workbook which always opens in full screen mode. But if I minimize the window and then maximize it again, the tool bar ribbon along the top shows - full screen mode has closed. I have 12 other worksheets which are all hidden. If I unhide one and toggle to it I have code which goes back to full screen. But if I minimize the window and maximize it again - full screen is closed again! I'd like the users to be able to minimize the window but when the open it back up I want it to open back up in full screen mode. Again, I have found suggestions from older posts but none of them work for me - the workbook just ignores it and closes full screen.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,122,364
Messages
5,595,714
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