Martin,
Use the TypeOf operator. E.g.,
If TypeOf Selection Is Excel.ChartArea Then
Debug.Print "Chart selected"
End If
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Martin Stender" wrote in message
oups.com...
Hi all,
I have done a lot of VBA programming in PowerPoint, but I'm new
to
Excel.
Now, want to manipulate charts, but I cannot figure out how to
detect
if on or more charts on the active sheet are selected or not.
How do you discern between 'selection types' in Excel?
Thanks in advance! :-)
Martin