Create a "Dead" Chart

  • Thread starter Thread starter Bill Roberts
  • Start date Start date
B

Bill Roberts

I used this code in an earlier program to create a "dead" chart (one that
would not update when the data changed). I get an error on
activechart.pictures.paste.select
Would appreciate the correct code for Excel2007. TIA

activechart.chartarea.copy
activechart.pictures.paste.select (this is where I get the error)
activechart.chartarea.select
selection.clear
activechart.deselect
 
Hi,

These 2 commands will create a picture of a chartobject.

activechart.copypicture
activesheet.paste

Cheers
Andy
 
Back
Top