View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Hopwood Michael Hopwood is offline
external usenet poster
 
Posts: 37
Default Dialog Box - User hits cancel

You need to trap the error and deal with it.

Post your code.

--
Michael Hopwood (Phobos)


"CS" wrote in message
...
I have a dialog box for inserting an image that pops up in my macro - if

the
user presses cancel - an error is reported (method not supported) how can

I
suppress this error?

Can I use some code like - if cancel is pressed exit sub?

Thanks,

Colin