View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_9_] Jon Peltier[_9_] is offline
external usenet poster
 
Posts: 146
Default Event Listeners on a protected chart

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.