Is there any way to use animated gif's in an Excel spreadsheet or userform without saving to an HTML format? I would like to ultimately incorporate a moving logo onto a splash screen as the workbook loads.
Thanks. I opted to use a webbrowser insert, which works well but.....
Any idea how to get rid of the vertical scroll bars and make the "window" appear flat (i.e. more like a straight image)? The gif image is small, and the bars are inactive, but there is no property value that I can find that seems to influence either display issue.
Create a shape and rename the "WordArt 1" to what ever your shape is named
This code will make the shape run from right to left when the sheet is activated.
Private Sub Worksheet_Activate()
Dim x As Single, y As Single, t As Single, i As Integer, n As Integer
With ActiveSheet.Shapes("WordArt 1")
.Top = 100
.Left = 400
n = 20
For i = 1 To n
.Left = 400 + (72.75 - 400) * i / n
Sub Wait(tSecs As Single)