Animated Gif on worksheet

[Mike K]

Oh Wise Ones,
Can I have an animated Gif on a worksheet? I tried
adding one and it would not animate. Is there some code to animate it?

Thanks,
Mike

[Leith Ross]

Hello Mike,

You can use animated gifs on an excel worksheet. There are several methods of doing it. You could save the workbook or worksheet as an html file, which is most cases isn't practical. Place the gif on a UserForm with a Browser Control to display it or visit Ivan Moala's site and download his code for saving the gif on a worksheet (so the user doesn't have to have access to the original file) which is then displayed on a UserForm. He also has an AddIn to save a gif file to a Worksheet.

Here is Ivan's URL http://xcelfiles.homestead.com/AnimatedGif.html

Sincerely,
Leith Ross