Hello, i want to make a global trigger on charts only as following :
If a user selected a single point on an X-Y Scatter Plot then Keydown event "Middle Mouse Button" : Run my Macro
Here are my problems :
1- I want to make this trigger global for all of my workbook charts even if user creates a new chart
2- I need to check if its an X-Y Scatter Plot and only single point is selected
3- I cant find keydown event on charts?
If a user selected a single point on an X-Y Scatter Plot then Keydown event "Middle Mouse Button" : Run my Macro
Here are my problems :
1- I want to make this trigger global for all of my workbook charts even if user creates a new chart
2- I need to check if its an X-Y Scatter Plot and only single point is selected
3- I cant find keydown event on charts?