Changing a Chart on a Protected Sheet

  • Thread starter Thread starter Peter M
  • Start date Start date
P

Peter M

I have a chart in a sheet that I wish to protect. Some of the cells, data
and control input, are obviously unprotected. As a consequence of the data
and control input the chart needs to have ranges added or deleted. With an
unprotected worksheet this works fine, but the line:

ActiveSheet.ChartObjects("Chart 6").Activate

fails when the worksheet is protected. I have looked at the properties of
the Activesheet and although there are a number of .Protection variables
I unable to find a combination that allows the changes I require.

Any help gratefully accepted.

Peter
 
When you protect the sheet, don't protect objects.

also make sure the chart is actually named Chart 6
 
Tom,

Many thanks, chart now works as expected.

For some reason I couldn't find the reply on the bulletin board and was
only aware of your reply through Developersdex.

Again, many thanks.

Peter
 
Back
Top