BeforeClose Procedure not working

[hyoung3]

Hi,
I am having trouble using the Workbooks_BeforeClose procedure in excel. Macros seems to be enabled because in order the use the spreadsheet the user must click a button with a macro assigned to it. Unfortunately, when the workbook is closed and reopened to procedure I assigned to the close never executes. Here is the code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    

    Sheets("Prospects").Select
    Sheets("Welcome Page").Visible = True
    Application.Run "BLPLinkReset"
    Sheets("Prospects").Select
    Application.Run "BLPLinkReset"
    Sheets("Prospects").Select
    ActiveWindow.SelectedSheets.Visible = False
    Application.Run "BLPLinkReset"
    ActiveWorkbook.Protect Password:="Password", Structure:=True, Windows:=False
    ActiveWorkbook.Save

End Sub

Why is this not executing?

 

[Smitty]

Welcome to the Board!

Have you tried putting a breakpoint on the first line and stepping through the code?

 

[hyoung3]

Yes. So I put a break point on the line "Sheets("Prospects").Select" and closed the workbook, but it closed without even stopping the procedure. I am kinda new to debugging so maybe I am going about it the wrong way.

 

[Smitty]

Sounds like you may have disabled Events, because the debugger stops for me.

In the Immediate window type:

?Application.EnableEvents

And hit enter. If it comes back False, you need to set it to True.

 

[hyoung3]

Ok, yes, it came back false. But where do I place the "application.EnableEvents = True" code? Also, just so I get an understanding about how to troubleshoot this in the future how did I disable events?

 

[Smitty]

Just type:

Application.EnableEvents = True in the Immediate Window and hit enter. That will reset it.

To see where you might have disabled events, I'd do a procedure search for "EnableEvents".

 

[hyoung3]

Great! Thanks so much for the help!