Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select an embedded Chart within a Protected Sheet
Hola,
I have an embedded chart within a protected worksheet. I want the user to be able to point and select a specific value within the chart but need to prevent her to "accidentaly" delete the entire chart. If I protect the chart, then it becomes read-only and the user cannot "see" the values on the chart. If I unprotect the chart, then the user can "see" the values but then she can accidentaly delete the chart. Any ideas to accomplish these? Regards, OMER |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select an embedded Chart within a Protected Sheet
Unfortunately in Excel 2007, which I assume you are talking about, chart
tooltips are not displayed if the chart is protected (ie objects or chart-sheet) as they were in earlier versions. They have been restored in Excel 2010, Regards, Peter T "OMER" wrote in message ... Hola, I have an embedded chart within a protected worksheet. I want the user to be able to point and select a specific value within the chart but need to prevent her to "accidentaly" delete the entire chart. If I protect the chart, then it becomes read-only and the user cannot "see" the values on the chart. If I unprotect the chart, then the user can "see" the values but then she can accidentaly delete the chart. Any ideas to accomplish these? Regards, OMER |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select an embedded Chart within a Protected Sheet
Thank you Peter T. for your prompt response.
I'm not happy with this Excel 2007 limitation. I'll have to find another approach to solve this problem. Thanks again. OMER "Peter T" wrote: Unfortunately in Excel 2007, which I assume you are talking about, chart tooltips are not displayed if the chart is protected (ie objects or chart-sheet) as they were in earlier versions. They have been restored in Excel 2010, Regards, Peter T "OMER" wrote in message ... Hola, I have an embedded chart within a protected worksheet. I want the user to be able to point and select a specific value within the chart but need to prevent her to "accidentaly" delete the entire chart. If I protect the chart, then it becomes read-only and the user cannot "see" the values on the chart. If I unprotect the chart, then the user can "see" the values but then she can accidentaly delete the chart. Any ideas to accomplish these? Regards, OMER . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disappear excel embedded messagebox in protected sheet | Excel Programming | |||
for each chart (sheet and embedded) | Excel Programming | |||
SELECT EMBEDDED EXCEL CHART | Charts and Charting in Excel | |||
what is the difference between embedded chart and chart-in-a-sheet | Excel Programming | |||
How to find a Chart embedded in a Sheet? | Excel Programming |