Macro doesn't start

[abourgault]

Hi all,

I have a workbook with several VBA macro.

One of them is in the ThisWorkbook module. It is a Workbook_open macro.
Usually when I open the workbook that macro is triggered and does its job. But often after I have added code in other modules not related to this one, I save and close and when re-opening nothing happen.

I have to revert to the last working version and copying all the changes I have made to have a workbook that works as intended.

Do you have any hints about what could cause that?

thanks,

André

 

[bjurney]

Check for this line of code

Application.enableEvents = false

If its in there, make sure you add that line again but add true to it. you may have to do an "unhook" in a sense.

Sub unhook
 
Application.enableEvents = True
 
End Sub

 

[abourgault]

Thanks bjurney,

There's no such code in my project.

To add to the explanation of the problem, once the workbook is open if I try to save it an error message appears saying that Microsoft Excel has stopped working.

André