be able to edit datalabel position of all series in a protected ch

G

Guest

Hi:

I have a password protected chart. Users print it but do not edit it.

Now, I want them to be able to edit only the position of the datalabels.

How would I do it? Please help.

Joy
 
W

William Benson

Duplicate the chart as another chart object, let the user edit the labels on
the copied chart, and then unprotect the first chart using VBA, cycle
through the labels of the copied chart, and set the now unprotected chart's
labels equal to the user's changes, before protecting it again. This way
they cannot mess with anything else in the protected chart, whether they
messed up the "copied" chart or not.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Be able to edit position of datalabels in a protected chart. 2
Edit datalabel positions in a protected chart 1
Chart DataLabel Placement Error 2
Excel Protection 2
Editing a Chart on a protected worksheet 3
Problem with Datalabel in Stacked bar charts 6
Please help 2
Method 'Left' of object 'DataLabel' failed 2

Top