Is it possible to limit a user's interaction with an embedded chart to
the
double-click (DoubleClick) event (from which a macro would be run)?
As far as I can make out, Excel's protection facilities - despite the
various .Protect* properties of a Sheet or Chart - will always put
DoubleClicking in the same category as formatting.

If it's not directly possible, I suppose I'm interested in
workarounds, but my customer wanted to have this particular type of of
user-interaction. At present, the chart itself is all that needs to
be selected. In future releases, it would be good to be able to
select a chart data point and provide a report or 'drill-down' view.
The design works well without protection, using the chart's
BeforeDoubleClick event: can this be made to work whilst we lock all
control of the chart formatting?

[revised version of original post to
microsoft.public.excel.programming]