Select an embedded Chart within a Protected Sheet

  • Thread starter Thread starter OMER
  • Start date Start date
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
 
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
 
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
How do I copy Chart shee to other workbook without external refere 2
Pivot Table on protected worksheet - 10
Protecting Embedded Chart 1
How to determine if a chart is embedded or not 7
best way protect unprotected cells 2
Automatically selecting active chart 4

Back
Top