Dave,
Sorry I didn't get back to you sooner. Unless I need to rename the bitmaps
after they are copied into the worksheet, yes the bitmaps with those names
are in the Pictures worksheet. Below are the steps that I have taken.

After your message, I deleted my current tickmarks.xlam, and started with a
blank document. I inserted all the bitmaps that I will need (total of 15)
into the document. I inserted them using the normal insert method (Insert
ribbon - Picture). I didn't touch the bitmaps I left them as is. I renamed
the Sheet1 tab to Pictures(which I copied and pasted the word "Pictures" from
your code). I then saved this new document as tickmarks.xlam. I then went
into the VB editor (Alt - F11) and copied and pasted your code. I then added
the macro's. The names that I added to the code for the bitmaps were
directly copied and pasted from the filename of the original bitmap in my
tickmark folder. I assumed that picture in the workbook woudl take the same
name as the original file name. The only error that comes up is "Compile
error: Syntax Error" and that line is highlighted.

Again any help would be appreciated.


"Dave Peterson" wrote:

And you have pictures named Prior_Year and Recalculated on a worksheet named
Pictures in that workbook with the code?

If no, then you have some work to do.

If yes, what error do you see?