View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Incidental Incidental is offline
external usenet poster
 
Posts: 226
Default 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