Exel VBA- userform startup problem
I would like to have my userform in Exel 2002 startup on top of th
Excel worksheet (like a splash screen) before the worksheet loads. What code do I use to make this happen and where would the code go? Thank you -- Message posted from http://www.ExcelForum.com |
Exel VBA- userform startup problem
I think you will get a flash of the worksheet/workbook regardless of what
you do, but you can make the application.Visible = False while you show the userform. -- Regards, Tom Ogilvy "officemanager " wrote in message ... I would like to have my userform in Exel 2002 startup on top of the Excel worksheet (like a splash screen) before the worksheet loads. What code do I use to make this happen and where would the code go? Thank you. --- Message posted from http://www.ExcelForum.com/ |
Exel VBA- userform startup problem
When you open up your VBA editor, view the code for 'ThisWorkbook' an
enter the following: Private Sub Workbook_Open() Application.Visible = False 'Hides Excel UserForm1.Show 'Shows your form Application.Visible = True 'Shows Excel once form closes End Su Code ------------------- Private Sub Workbook_Open( ------------------- -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com