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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,122,473
Messages
5,596,356
Members
414,061
Latest member
JJSB

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