View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peterke Peterke is offline
external usenet poster
 
Posts: 16
Default userform question

Hi,

Having a smal problem.
First here's the code i use:

Private Sub Workbook_Open()
Application.WindowState = xlMinimized
UserForm1.Show
End Sub

When the workbook opens it gets minimized, so that part is ok.
The userform does not appear on the screen, i have to click below to see the
userform.
How do i make the userform appear on the screen without clicking below?

Regards,
Peter