Hi, i have difficulty inserting animated GIF onto my excel 2007 spreadsheet. I have visited website and was advised to use web control.
The following are my VBA codes but it could not display the gif.
Private Sub WebBrowser1_NavigateComplete2(ByVal pDisp As Object, URL As Variant)
Private Sub Worksheet_Activate()
WebBrowser1.Navigate "F:\BAR Project\Hole in 1.gif"
End Sub
Pls enlighten. James
Bookmarks