Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First, hold shift while selecting the chart, to select the chart object
(it's surrounded by white handles, not the usual black handles). Press Ctrl+1 (numeral one) to format it, and on the Protection tab, uncheck the Locked checkbox. This will completely unprotect the chart. To prevent bad things being done to the chart, but still make its mouse events live, execute these VBA commands: activechart.ProtectSelection=true activechart.Parent.protectchartobject=true - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ James Martin wrote: Is there anyway to have event listeners (mouse clicks and moves) on a chart that is protected? I'm fairly certain it is impossible because the chart must be active for the events to happen and you can't make the chart active if it's protected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart MouseUp Event Feedback | Charts and Charting in Excel | |||
Change Chart Name Event | Charts and Charting in Excel | |||
Delete Chart Event | Charts and Charting in Excel | |||
Is there some way (event) to know when an embedded chart is deleted? | Charts and Charting in Excel | |||
Excel Chart Event Coding | Excel Programming |