Force window when open to full size

[ipbr21054]

Hi,
More often than not when i open a worksheet it doesnt open to the full max window.
Sometimes then when i go to click the X i actually click the X in the page behind so closing that page & not the one i am on.

Is there an option to have it opened full max size each time.

 

[SanjayGMusafir]

Hi,
More often than not when i open a worksheet it doesnt open to the full max window.
Sometimes then when i go to click the X i actually click the X in the page behind so closing that page & not the one i am on.

Is there an option to have it opened full max size each time.

I may be wrong but best to my knowledge when you open second window, it generally opens in a smaller window... Since it has been years since I used Windows - Still double clicking the top bar maximises the window to the screen size.

 

[ipbr21054]

Ok but thats the same as me just clicking the middle icon each time,just thought it was going to be a tick in the box option

 

[SanjayGMusafir]

Ok but thats the same as me just clicking the middle icon each time,just thought it was going to be a tick in the box option

Then VBA can be a solution

Check this and revert -

Window.WindowState property (Excel)

Office VBA reference topic

learn.microsoft.com

 

[ipbr21054]

So would I need to right click each tab & paste on each worksheet at the bottom ?

If not please advise thanks.

 

[SanjayGMusafir]

I think it should be as below. As we need to run it as and when Workbook is open -

Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub

Before using above check the two links below -

Automatically run a macro when opening a workbook - Microsoft Support

Use Auto_Open to create a macro that runs every time you open a specific workbook.

support.microsoft.com

Window.WindowState property (Excel)

Office VBA reference topic

learn.microsoft.com

 

[ipbr21054]

Many thanks for that

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.