Default Opening Spreadsheet Size

[mwinnick]

Running Windows 7 and Excel 2013 (as part of Office 2013 Home & Business).

When I try to open a spreadsheet (existing one) it opens in a small window and I have to resize it and move it to the left side of the screen (I want it to use the left side top to bottom. Even if I then save the sheet and close it and Excel, when I open it again it still opens in a small window.

When I try to drag the sheet to the left it insists on snapping open to full screen which I do not want.

How can I force Excel to open any sheet in a specific size and location? I did not have this problem in Excel 2007.

 

[CodeNinja]

In the workbook open you can put the following code (adjust width and height as you desire)

Private Sub Workbook_Open()
    Application.Width = 830
    Application.Height = 520
    
End Sub

 

[mwinnick]

Appreciate quick reply.

I guess I didn't clarify, or maybe this board is just for programming questions.

I do not want to add code to every worksheet. I want to start up Excel and then open any existing sheet and expect Excel to open it in the same position I opened it on last use or save.

Prior to moving to 2013, using 2007, I always opened each sheet and had it placed at the left side of the monitor and use half the width of the monitor. I saved sheets from there. I do that because I typically work on another application and want to view a sheet without covering up that application entirely.

 

[CodeNinja]

Sorry, I do not have 2013 and do not know how to adjust those default settings.

 

[mwinnick]

OK, understand.