Jump to content
Sign in to follow this  

Maximise Excel Sheets

Recommended Posts


Hi All,

Is there a way to maximise the spreadsheets in excel. I can maximise the main Excel window but not any spreadsheets that are not maximised when excel opens.

I have this at the top of my script:

opt("WinTitleMatchMode", 2)

opt("WinSearchChildren", 1)

and I tried this in the script:

WinSetState("Microsoft Excel", "Worksheet in Basis (1)", @SW_MAXIMIZE)

"Worksheet in Basis" is the spreadsheet I want to maximise.

Hope I have explained it well enough. Thanks in advance for any pointers


Share this post

Link to post
Share on other sites

This is a clumsy workaround but you can maximise the active spreadsheet by sending keys to the Excel window:


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this