Select an embedded Chart within a Protected Sheet

O

OMER

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
 
P

Peter T

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
 
O

OMER

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
 

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

Embedded Chart protection 1
Editing a Chart on a protected worksheet 3
Creating a Chart on form from selected data in query. 0
Override protected sheet message? 4
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Pivot Table on protected worksheet - 10
Protecting Embedded Chart 1
How to determine if a chart is embedded or not 7

Top