Set window size with VBA.

Hey guys,

I'm looking for a way to use VBA to set the window size upon opening the workbook. When the document opens, there should be two windows, each taking up half the screen and each on a particular tab.

Currently, if I save the workbook with the window settings I want, when I open it, both windows are maximized. When I hit the restore button, they go back the settings with which they were saved, which is what I want it to look like as soon as it's opened.

Also, a bonus would be for the code to determine the screen size, so it can fill the screen no matter what monitor/computer it's opened on.

Thanks,
Kyle

Assuming the correct windows are open,

Please Login or Register  to view this content.

Thanks to both of you. Here's what I ended up doing:

InThisWorkbook:

Please Login or Register  to view this content.

How do I mark the thread as solved? I'm new around here.

How do I mark the thread as solved?

See the Forum Rules