VBA Error on Exit Sub

[Excel18]

Hello,
I have several macros configured to pull data into a worksheet. They both function correctly until the very end of the code, when I get an error on Exit Sub. This error is "Code execution has been interrupted". This does not occur every time the macro is run, and if I run it under the same conditions without closing the sheet it only fails every 4-5 times.

Does anyone have any advice on fixing this problem?
Thank you

 

[Norie]

Can we see the code?

 

[Excel18]

I'm actually not able to post the code. However, I think I have found a solution. Since the error and corresponding pop-up only occur at the very end of the macros, I put "Application.EnableCancelKey = xlDisabled" immediately before the End Sub.

Thank you for your willingness to help!