Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selective protection | New Users to Excel | |||
Protection of Pivot charts | Charts and Charting in Excel | |||
Selective cell protection | Excel Worksheet Functions | |||
confined space entry permit | Excel Worksheet Functions | |||
Where can I find a parking permit template? | Excel Discussion (Misc queries) |