Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
start up screen
Is there a way i can create a screenshot that appers for 3 seconds whe
i open up my spreadsheet -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
start up screen
Jamie,
Build yourself a userform, and in its activate event, use OnTime to forward schedule a macro that closes the form down. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "jamie85 " wrote in message ... Is there a way i can create a screenshot that appers for 3 seconds when i open up my spreadsheet? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
start up screen
http://j-walk.com/ss/excel/tips/tip39.htm
Create a Splash Screen at John Walkenbach's site -- Regards, Tom Ogilvy "jamie85 " wrote in message ... Is there a way i can create a screenshot that appers for 3 seconds when i open up my spreadsheet? --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
start up screen
Commonly called a "Splash Screen"
This will require a few steps: 1) Design a Userform that you want to appear (let's say it is calle UserForm1) 2) Code the UserForm to open upon opening the workbook. This wil need to be done in the "This Workbook" part. Private Sub Workbook_Open() UserForm1.Show End Sub 3) Code the timing after it opens Private Sub UserForm1_Activate() Application.OnTime Now + _ TimeValue("00:00:03"), "KillTheForm" End Sub 4) Code the "Kill the form" module that you call in the las procedure... Private Sub Killthe Form() Unload Userform1 End Su -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
start up screen
Jamie:
I have a splash screen that may be what you need, l will email it to you..no problem... seeya ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen. Width Screen.height | Excel Discussion (Misc queries) | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
Start spreadsheet with WinXP start | Excel Worksheet Functions |