Protecting chart objects

I would appreciate any suggestions. I have a question concerning
protected charts.

I am currently creating charts on a worksheet, a different chart
depending upon the option button the user selects. I was told to make
sure that the user can not select the chart, move the chart, delete the
chart. I am creating my charts in a particular range. So when the
user selects an option button for a different chart ... the previous
chart object is deleted, and a new one is created and placed in the
range. How can I protect each chart, considering the creation and
removal of charts going on in my workbook?

Thanks in advance,
Julia

In your code,
unprotect the sheet,
delete the old chart
build the new chart
protect the sheet (at least for objects)


Charts are on the object layer, so you have to at least protect objects.

--
Regards,
Tom Ogilvy

<julia.stone@gmail.com> wrote in message
news:1113824423.960876.99640@l41g2000cwc.googlegroups.com...
> I would appreciate any suggestions. I have a question concerning
> protected charts.
>
> I am currently creating charts on a worksheet, a different chart
> depending upon the option button the user selects. I was told to make
> sure that the user can not select the chart, move the chart, delete the
> chart. I am creating my charts in a particular range. So when the
> user selects an option button for a different chart ... the previous
> chart object is deleted, and a new one is created and placed in the
> range. How can I protect each chart, considering the creation and
> removal of charts going on in my workbook?
>
> Thanks in advance,
> Julia
>

Thanks for the response. Would the following suffice?

ActiveSheet.Protect DrawingObjects:= True ' To protect chart object

And I am assuming I would change the above to false to unprotect? If I
am incorrect would you mind to point me in the right direction?

Thanks

That would be it.

--
Regards,
Tom Ogilvy

<julia.stone@gmail.com> wrote in message
news:1113825853.801188.135310@l41g2000cwc.googlegroups.com...
> Thanks for the response. Would the following suffice?
>
> ActiveSheet.Protect DrawingObjects:= True ' To protect chart object
>
> And I am assuming I would change the above to false to unprotect? If I
> am incorrect would you mind to point me in the right direction?
>
> Thanks
>

Julia, you will need to Protect Objects after you create a chart and then
Unprotect Objects before you delete it.

Mike F
<julia.stone@gmail.com> wrote in message
news:1113824423.960876.99640@l41g2000cwc.googlegroups.com...
>I would appreciate any suggestions. I have a question concerning
> protected charts.
>
> I am currently creating charts on a worksheet, a different chart
> depending upon the option button the user selects. I was told to make
> sure that the user can not select the chart, move the chart, delete the
> chart. I am creating my charts in a particular range. So when the
> user selects an option button for a different chart ... the previous
> chart object is deleted, and a new one is created and placed in the
> range. How can I protect each chart, considering the creation and
> removal of charts going on in my workbook?
>
> Thanks in advance,
> Julia
>

Would you mind to share a code sample with me? Any help is
appreciated.

Thanks