Delete old chartobject and create a new named one?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tskogstrom - 18 Oct 2006 06:20 GMT

Hi,

I need a subroutine that delete the old chartobject in a worksheet,
create a new chartobject , name it as I want.

Reason is that if the user delete the chart, I want to recreate it. I
know how to protect it but feel that the user had to be able to change
labels, colors etc.

More than grateful to every suggestion!

Kind regards
tskogstrom

Reply to this Message

Andy Pope - 18 Oct 2006 20:42 GMT

Hi,

This will delete a chart object, but not sure how you are identifying
which chart object.

Activesheet.chartobjects(1).delete

' create and give it a name
with Activesheet.chartobjects.add(1,1,400,300)
.name = "MyName"
end with

For more details see Jon's page(s)
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

Cheers
Andy

> Hi,
>
[quoted text clipped - 9 lines]
> Kind regards
> tskogstrom

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

tskogstrom - 22 Oct 2006 13:30 GMT

Thank you, Andy
this will help.
/Regards
tskogstrom

Andy Pope skrev:

> Hi,
>
[quoted text clipped - 27 lines]
> > Kind regards
> > tskogstrom

Reply to this Message