Stop Macro Thread from Running

[mlegge77]

I have a set of Macros that are called simultaniously using the code below. In the first Macro "Get_Data22" it opens a file selected from a window, the macro itself has an error handler to End Sub if no file is available. Although the way I have set this up to run is that the code still proceeeds to move onto the "SaveWithVariable22" Macro. I was wondering if there was any error condition i could add to stop "Sub RunAll22" from running all the other pieces of code.

Thanks
Michael

Sub RunAll22()
Call Get_Data22
Call SaveWithVariable22
Call Auto_Open22
Call OpenWorkbook22
Call Operations22
Call FilterSelect22
Call SelectAll22
Call Ratio_BC22
Call RemoveDups22
Call AllWorksheetPivots22
Call CloseMacro22
End Sub

[Mumps1]

Hi Michael. I'm not sure if this would work but you could try to replace 'End Sub' with just 'End'.

[mlegge77]

Hi,

Thanks both for the suggestions. Mumps1 I tried your suggestion and it worked flawlessly!

Thanks soo much

Michael

[Mumps1]

My pleasure.