Can Anyone Help Me With VBA Code that "Untiles a Background"...

[Lidsavr]

I am running Excel 2007.

I have written code that adds a .jpeg background to several charts in a workbook (in the chart area, not the plot area). The problem I am having is that the Excel 2007 appears to default to a tiled background. I have to manually go to each chart and open the background format and uncheck the "Tile picture as texture" checkbox to get the jpeg to the right size. Next week, when I update the charts, I have to do this again.

I have researched a lot of reference material for code that will uncheck the checkbox when I add the picture and cannot find anything.

Does anyone know the one line code to uncheck the box? It would save me a lot of time each month.

Thanks,

Charles

 

[John_w]

I don't know the answer, but try doing the manual steps with the macro recorder and see what VBA code is generated.

 

[Lidsavr]

John_w,
Thank you for replying. I have done that.

The Excel Macro Recorder in version 2007 stinks (I thought of other words, but would like to keep this forum G-Rated). The code that the recorder creates when making and modifying charts does not work when working with charts.

I read on one of the Excel guru's that when 2007 was being created, Microsoft was very concerned about memory consumption, so they deleted a lot functionality from the program that was not often used. I think the macro recorder/charts was one of them.

My best to you. I'll keep searching.

Charles