Opening Size of Spreadsheet

P

Powlaz

This may be a stretch, but what I did was make a very
small section of a spreadsheet a little program. Is
there a way to set the windowsize of the workbook when it
opens?

If I new VB I could make this little program on a canvas
that opens to the size that I want. I can do it in Excel
but I don't need the spreadsheet or Excel (for that
matter) to open maximized.

thanks for the help,

matt
 
V

Vasant Nanavati

Paste the following code into the ThisWorkbook code module:

Private Sub Workbook_Open()
With Application
.WindowState = xlNormal
.Height = 300
.Width = 500
.Top = 100
.Left = 100
End With
End Sub

Adjust the numbers to suit.
 
P

Powlaz

Thank you, very helpful!

Matt
-----Original Message-----
Paste the following code into the ThisWorkbook code module:

Private Sub Workbook_Open()
With Application
.WindowState = xlNormal
.Height = 300
.Width = 500
.Top = 100
.Left = 100
End With
End Sub

Adjust the numbers to suit.

--

Vasant








.
Click to expand...
 
Top