Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Welcome screen...
hi.
I´ve made a welcome screen in may worlbook and past the code inside workbook.open so it would load when my workbook opens. The problem is that i what the welcome screen to appear before my workbook is visible below! How can do this?? Thansks SpeeD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Welcome screen...
the delay in this demo is 10 seconds ...
Private Sub UserForm_Activate() Dim t As Date Application.Visible = False t = Now() Do While (Time) < TimeSerial(Hour(t), Minute(t), Second(t) + 10) DoEvents Loop End Application.Visible = True End Sub "SpeeD" wrote: hi. I´ve made a welcome screen in may worlbook and past the code inside workbook.open so it would load when my workbook opens. The problem is that i what the welcome screen to appear before my workbook is visible below! How can do this?? Thansks SpeeD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputbox Location on Screen. Can you code it to popup lower on the screen ? | Excel Programming | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Programming | |||
How to copy data from excel to power point screen by screen? | Excel Programming |