Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Be able to edit position of datalabels in a protected chart.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Be able to edit position of datalabels in a protected chart.
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. -- Cheers Nigel "Joy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Be able to edit position of datalabels in a protected chart.
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 In article , says... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Lock the chart but leave datalabels position editable | Charts and Charting in Excel | |||
Edit datalabel positions in a protected chart | Charts and Charting in Excel | |||
How to assign datalabels to a scatter chart, obtaining the labels. | Excel Discussion (Misc queries) | |||
Excel Chart Datalabels | Excel Programming |