So i searched google for a fix, and the only solution seemed to be to add the following line of code to the start of the function:
“Application.EnableCancelKey = xlDisabled”
This was a quick and dirty solution, but it didn't explain the root cause of the problem.
After a bit of investigation i found that on another worksheet i had some cells referencing a function that no longer existed, and for some bizarre reason my macro on a totally different worksheet that was getting interrupted was triggering those cells to update - no idea why!
So i deleted the cells that referenced the missing function, and the problem went away.
Not 100% sure if that was the route cause, but it did seem to solve my problem on this occasion :)
happy coding guys and girls :)
No comments:
Post a Comment