VBA code equal to right-clicking an image, selecting Edit and then hitting Enter? Possible?

[9tanstaafl9]

I tried this in the macro recorder and nothing shows up other than that I clicked the image.

I need to do this because if not, the image causes an error every time the report is saved, and I don't want users to have to do it. The report is a file exported from Crystal Reports into an Excel 98-2003 format, opened by users in 2010. I have a macro that makes it pretty and adds formulas etc. All is working well except I get an error on save. I figured out that the cause of this error is their logo.

If I manually right click the logo and choose edit, the window says: "This is an imported picture, not a group. Do you want to convert it to a Microsoft Office Drawing Object?" The default (which I want) is YES.

Is there a way to do this using VBA? The report generates several times daily, so I can't just fix it otherwise.

Also, this is a rewording of another post I made, which was getting no views I think because my title scared people off. I don't need to know how to covert it, just how to choose the default button and bring up the editing box.

 

[9tanstaafl9]

NEVERMIND

I can remove the error by simply saving using the 2010 "Excel Workbook" choice instead of the Excel 97-2003 format it was defaulting to.

As an aside, does anybody know if there is a way to delete a post that is no longer needed?