View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AG[_3_] AG[_3_] is offline
external usenet poster
 
Posts: 50
Default Exit Sub when File Open Dialogbox is cancelled

Hi,

This should be fairly simple for a lot of you but I am struggling with
it. I have a macro that opens up a dialog box to allow users open the
input data file to be processed using macro. Many a times users click
cancel instead of opening the file and in that case I get a run time
error.

What is want is when the users cancel it should just give them a
message and macro should end while if they opened the input file then
the rest of the macro should run.
Can someone help me with this? Thanks.

- AG