userform question

P

Peterke

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top