J
jamie85
Is there a way i can create a screenshot that appers for 3 seconds whe
i open up my spreadsheet
i open up my spreadsheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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)
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)
T
Tom Ogilvy
J
jpendegraft
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
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
S
ste mac
Jamie:
I have a splash screen that may be what you need, l will email it to
you..no problem...
seeya ste
I have a splash screen that may be what you need, l will email it to
you..no problem...
seeya ste