Run-time error stops all workbooks

Ash

Are you disabling events at any point?

Ash

Well it sounds like the macros the aren't running are event code and if events were disabled that would stop them from running.

Can you access the code that causes the error?

Agree with Norie. Sounds as though you have Application.EnableEvents = False at some point. Seems that you haven't got any, or adequate, error handling. So, when the error is presented, the code does not complete and, consequently, you do not switch on Event handling. That then means that workbook open and close events won't be actioned ... anywhere. Nor will change or selection event handlers.

It will require a review of your code and the error handling to be enhanced.

Regards, TMS

In the meantime, you could create a separate macro enabled workbook that simply contains one sheet with one button that runs the "recovery" code.

Please Login or Register  to view this content.

See the attached example workbook.

Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.