Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with Excel Startup problem | Excel Discussion (Misc queries) | |||
Excel Startup Problem | Setting up and Configuration of Excel | |||
Startup Problem | Excel Discussion (Misc queries) | |||
Excel Startup Problem | Setting up and Configuration of Excel | |||
startup macro problem | Excel Programming |