Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Protect chart source links but allow change font and colors etc?
Hi,
I find that neither "Protect Worksheet for Contents" nor "Protect Worksheet for Contents" are suitable. I want to protect charts from changing source and delete and cut them. However, I also want to be free to change fonts and colors etc. How can I make this happend? Anybody already having done this and can share the code? Can I take some action with vba on sheet_change event somehowe? This are the options I find that doesn't give me this possibility: - Protect Worksheet for Contents This option prevents changes to the chart's formats. Chart elements may be selected, but may not be changed. This option also prevents changes to a chart's data links, either through the series formula or through the Source Data dialog. If there are changes to worksheet data that the chart is linked to, the chart will update. Any objects (text boxes or shapes) on the chart are not protected. - Protect Worksheet for Contents This option prevents changes to any objects (text boxes or shapes) on the chart. If the text box is linked to a worksheet cell, and the contents of the cell change, the textbox will update. The formatting and source data of the chart may be changed. / Kind regards (Same message in microsoft.public.excel.charting) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change font colors in the header of an excel document? | Setting up and Configuration of Excel | |||
change links to a different source in the same workbook | Excel Discussion (Misc queries) | |||
Why can I no longer change Font colors in an Excel 2007 Comment? | Excel Discussion (Misc queries) | |||
How do i change font colors for different results in the same cel. | Excel Worksheet Functions | |||
Format a cell to recognize data and change font colors accordingly | Excel Worksheet Functions |