Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart MouseUp Event Feedback Amit Velingkar [MSFT] Charts and Charting in Excel 2 October 26th 09 02:06 AM
Change Chart Name Event Todd Charts and Charting in Excel 0 March 19th 09 04:27 PM
Delete Chart Event El vengador de la capa Charts and Charting in Excel 3 December 13th 08 11:32 AM
Is there some way (event) to know when an embedded chart is deleted? [email protected] Charts and Charting in Excel 9 February 11th 05 03:26 PM
Excel Chart Event Coding ramkee27 Excel Programming 0 February 20th 04 02:59 PM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"