userform question
Hi,
There seems to go something wrong, i've posted a question twice allready but it does not seem to appear, therefor here it comes again and hopefully it gets thru. Here's the code i use: Private Sub Workbook_Open() Application.WindowState = xlMinimized UserForm1.Show End Sub And here's the problem: When the workbook opens it's minimized, so that's ok. However the userform does not appear on the screen automaticly, i have to click below to actually show it. Now the question: How do i make the userform appear on screen without clicking for it? Regards, Peter |
All times are GMT +1. The time now is 12:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com