graphic animation

I know this is probably not that complicated for most people in this forum, but I'm a noob when it comes to VBA.

I've extracted a series of pictures from an animated gif. I'd like to paste them on a worksheet (presumably on top of each other) and then change their Visible properties to make only one visible at a time (basically recreating the effect of the original animated gif). I gather this can be done with a macro and appropriate VBA coding, but if there's another way to do it that would be be fine as well (though I want the images to appear on the sheet itself and not a Userform). I am using Excel 2003, but I want to be able to send the spreadsheet to others (which means the pictures need to be in the worksheet itself, and not on a local or networked drive), who may be using earlier or later versions.

I've seen questions (and solutions) posted here about changing Visible properties based on various events, but haven't been able to adapt them to my situation, due to my unfamiliarity with VBA.

I'd appreciate any help and suggestions.

Thank you.

First, Excel is not really a good tool for this. Unfornuately Excel (I am using 2007 at the moment) does not display animation for animated GIFs so I can't suggest that.

This code works if I step through it using the debugger but it doesn't have any effect if I just run it. I thought maybe it was just running too fast so I put a pause in it, but that didn't help.

Perhaps someone who has actually done this can help.

Please Login or Register  to view this content.

Maybe this (simple) example will get you going?

Originally Posted by WHER

Maybe this (simple) example will get you going?

Can you describe where function fotochoose is defined and how it works?

"fotochoose" is a named formula, see Insert >> Names >> Define
In this example cell D44 was selected, then the camera tool was used to create a mirror image of cell D44 in column F, with this mirror image selected, i clicked in the formulabar and renamed it: =fotochoose