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.