Opening Size of Spreadsheet
 

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

Opening Size of Spreadsheet
 

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





"Powlaz" wrote in message
...
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

Opening Size of Spreadsheet
 

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





"Powlaz" wrote in
message
...
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


.