Workbook_Open Not working!!!

[atf32]

Working in MS Excel 2010

HELP!! I have a problem where "Workbook_Open" does not execute when I open the file. It is in a trusted location and I even put "stop" in the beginning of the code, before I saved and closed the file.... And the code never executed. I even created a simple blank macro-enabled file, with a "Workbook_Open" sub, that included a "stop" line, and that works as expected (i.e., stopped on "stop" line).

 

[Juubi]

Hi

Im no Expert here but I found that if you have open a workbook with this code and you open another file the function will stop working
Private Sub Workbook_Open()
Application.EnableEvents = False

What I did I put Application.EnableEvents = true before the thing ends.

Private Sub Workbook_Open()
Application.EnableEvents = False


Application.EnableEvents = true

End