Hi
I am attempting to add some error handling to a process that allows the
user to save the active chart as an image. The first thing the process
does is request a filename, and at the moment I have added in an 'On
Error Goto' command to skip the rest of the code. My question is this
- is it possible to find out what the current selected object type is
and if not a chart then invoke an error? For example, if the user had
simply selected a cell, and not a chart object, it would not ask for a
filename but give the user an error message, whereas if the user had
correctly selected a chart object (either on a chart sheet or as an
object in a worksheet), it would proceed to ask for the filename to
save the image to.
I hope this makes sense - I don't think it's easy, but also not
convinced that its not doable, so if anyone has a way to do this, I'd
be most grateful.
Regards
Martin