Use VBA to resize the window

[NickDC1964]

I'm trying to create a spreadsheet for a client that will automatically size itself to a specific size when it is opened. I've googled a dozen things, none of which seem to work. The most common seems to be this code:

Sub SetWindowSize1()
Application.WindowState = xlNormal
Application.Top = 25
Application.Left = 25
Application.Width = 300
Application.Height = 200
End Sub

But Excel hangs up every time. All I need is for the spreadsheet to resize its own window to a set size that I pick when it opens. Any suggestions?

 

[alansidman]

When I put the code in the Workbook Open Event, it seems to work ok for me.

Private Sub Workbook_Open()
Application.WindowState = xlNormal
Application.Top = 25
Application.Left = 25
Application.Width = 300
Application.Height = 200
End Sub

I'm using Win 10 and Office 2016

 

[NickDC1964]

Thanks, I figured out the problem - the code doesn’t work on Excel for Mac, but works fine on Windows. I’d been doing the design work on my Mac.