userform question

P

Peterke

Hi,

I'm using this code to open my workbook:

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

Here's my problem:
The window is minimized so that's ok, but the userform does not come on
screen. I have to click below to show the userform.
How do i show the userform on screen without clicking below?
Please advise.

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

userform question 0
UserForm show mode 4
userform question 1
userform question 1
userform question 0
Question about modal userform..... 2
Call random UserForm from list 10
Code Fails to open UserForm 2

Top