What I have is a worksheet with a variety of charts. I have protected the
spreadsheet so that the users can't mess it up by accident or intentially.
However, I need to be able to capture the information that is displayed when
the user mouses over a bar on the chart, so that when the chart is clicked, I
can use that data to create/goto a subsequent drilldown chart on another
worksheet.

I believe by protecting the primary worksheet, excel/vba will not allow me
to capture of the mouse over information. Is there a way I can do this
without exposing the worksheet to potential modiciation from end-users?

Thank you in advance for any assistance.

Dean -

A chart's events will not fire unless the chart is activated. However, you can allow
activation of a chart without allowing changes. Check out the ProtectContents,
ProtectFormatting, and ProtectData properties of a chart.

If you need help to get the chart information, try one of these:

http://peltiertech.com/Excel/Zips/Ge...ChartSheet.zip
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Dean Hinson wrote:

What I have is a worksheet with a variety of charts. I have protected the
spreadsheet so that the users can't mess it up by accident or intentially.
However, I need to be able to capture the information that is displayed when
the user mouses over a bar on the chart, so that when the chart is clicked, I
can use that data to create/goto a subsequent drilldown chart on another
worksheet.

I believe by protecting the primary worksheet, excel/vba will not allow me
to capture of the mouse over information. Is there a way I can do this
without exposing the worksheet to potential modiciation from end-users?

Thank you in advance for any assistance.