I'm trying to write a macro that detects when a chart is clicked on in
any sheet in any workbook. This would include charts within a sheet
and charts in a separate sheet by themselves.
I understand how to catch application level events and was thinking
that the SheetSelectionChange event would give me enough to capture
this, but it doesn't seem to.
Does anyone have any idea how to do this? Any help would be
appreciated!
My code (such as it is!) is shown below:
Public WithEvents App As Application
Private Sub Workbook_Open()
Set App = Application
End Sub
Private Sub App_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
MsgBox "Sheet Selection Change"
'+ ADDITIONAL CODE HERE
End Sub
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
