View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tara H Tara H is offline
external usenet poster
 
Posts: 28
Default Show Image When File Opened

One option would be to have your logo image on a form, and put the following
code in the Activate event:

Private Sub UserForm_Activate()
UserForm1.Repaint
PauseTime = 2 ' Set duration in seconds
Start = Timer ' Set start time.
Do While Timer < Start + PauseTime
Loop
Finish = Timer
UserForm1.Hide
End Sub

(code from post by Mike H)

"bony_tony" wrote:

How can I get a logo image to show for a couple of seconds every time
a file is opened?
Hide the image on a sheet then unhide it??
Cheers