Animated Gif on worksheet

[Guest]

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