Re-size active window
 

is it possible to change the size of the Excel window with VBA?

not minimize but set to certain height/width parameters

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

Re-size active window
 

Hi

You could use something like the code below to change the size of the
excel app

Private Sub Workbook_Open()
With Application
.WindowState = xlNormal
.Height = 200
.Width = 200
End With
End Sub

Hope it helps you out

S

Re-size active window
 

perfect thanks



Incidental wrote:
Hi

You could use something like the code below to change the size of the
excel app

Private Sub Workbook_Open()
With Application
.WindowState = xlNormal
.Height = 200
.Width = 200
End With
End Sub

Hope it helps you out

S

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1