View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Powell David Powell is offline
external usenet poster
 
Posts: 3
Default Selective protection of charts: permit only BeforeDoubleClick ?

Is it possible to limit a user's interaction with a chart to the
double-click event (from which a macro is run)?
As far as I can make out, Excel's protection facilities are either all
'on' or all 'off' for chart objects (apart from a .ProtectChartObject
property which apparently addresses the chart frame itself).

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?