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? |
All times are GMT +1. The time now is 11:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com