ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userform question (https://www.excelbanter.com/excel-programming/357106-userform-question.html)

Peterke

userform question
 
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




All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com