| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
be able to edit datalabel position of all series in a protected ch
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
be able to edit datalabel position of all series in a protected ch
see my reply to your previous post!
-- 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. How would I do it? Please help. Joy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
be able to edit datalabel position of all series in a protected ch
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 "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. How would I do it? Please help. Joy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit/Fill/Series on Protected Sheet | Excel Discussion (Misc queries) | |||
| DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003) | Charts and Charting in Excel | |||
| Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Be able to edit position of datalabels in a protected chart. | Excel Programming | |||
| Edit datalabel positions in a protected chart | Charts and Charting in Excel | |||
Linear Mode
