Be able to edit position of datalabels in a protected chart.

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 of
all series.

How would I do it? Please help.

Joy
 
N

Nigel

If you want the user to interact with Excel then you will need to unprotect
the sheet first. However by doing so they could change
anything else on the chart!

You could write a user interface that allows the user to choose the option
under program control. So the process would be.....

1. User Chooses option to change Label Location
2. Display a Userform of options
3. User chooses Option
4. Unprotect sheet
5. Apply change
6. Protect sheet
7. Unload the useform

If this is close to your requirements you need to be specifc about what
things and how the user can change them.
 
T

Tushar Mehta

Do remember to check the responses to all your other posts on the same
subject in both .charting and .programming.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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 datalabel position of all series in a protected ch 2
Chart datalabels linked to cells 1
Apply different color to datalabels 3
DataLabel Manipulation 1
Chart DataLabel Placement Error 2
Edit datalabel positions in a protected chart 1
how to change font size of datalabels of two charts in a sheet 1
two charting problems with excel 2007 2

Top