Rotating Chart Objects

[Huey462]

I have a spreadsheet that, someone else made, which acts as a countdown timer. I would like to change the Chart Object pictures from the SI Swimsuit to pictures of home. I cannot, for the life of me, figure out how to add multiple pictures as a chart object, much less have it change with the VBA code below. I have tried searching these forums and the web as a whole, but with no success. More than likely I was looking for the wrong stuff. Any help would be greatly appreciated.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>

Private Sub Workbook_Open()
    Sheets("Sheet1").ChartObjects.Visible = False
    x = Day(Now())
    Sheets("Sheet1").ChartObjects(x).Visible = True
End Sub

<o> </o>
Thanks in advance
-Huey

 

[Huey462]

Can it be? I've stumped the MrExcel experts? Surely not.

 

[Section VIII]

Change: Sheets("Sheet1").ChartObjects.Visible = False

To: Sheets("Sheet1").ChartObjects.Visible = True

Then rerun the code (or save and then re-open spreadsheet) and all the chart objects with the pictures will be visible. Edit each one with the photo of your choice. Once done, change the first line of the code back to what it was.

BTW: I know where you probably got the file from