Does the VBA editor have the ability to detect if a macro has been paused

[x-amount]

I am writing a macro that runs a list of macros, the list of which is chanegablem, and defined in a table on a worksheet (using application.run(range("A1").value) etc)

However whilst this is all in the develpment stage, and I frequently pause the macros (or an error is found!).

I have an idea that will enable me to 'time' each macro run thus allowing me to estimate an eta for it's run completion. I will have the last 10 uninterrupted runs of each macro then average them out to calculate the total eta.

However, I need to be able to not add a run of each macro to the average time calculation if I have paused the run of the macro. My question is then: Is it possible to detect the pausing (or error-ing) of a macro?

 

[JamesW]

Hi,

You can use On Error.

Check this out:

http://www.cpearson.com/excel/errorhandling.htm

 

[x-amount]

Thanks for your response, but not how that would work with regards to manual ctrl+break pauses?

A pause is not an error (or is it?!)

 

[RoryA]

It is if you add:

   Application.EnableCancelKey = xlErrorHandler

to your code.