Personal.xls prompting to save, BeforeClose Event not workin

[MandelBrah]

I'm perplexed!!!

I have several macros that I coded in my Personal.xls file. For a while the following code suppressed the prompt to save each time I exited the application:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
If Me.Saved = False Then
Me.Save
End If
End Sub

Now it has started prompting me again. I tried running Application.EnableEvents = True but this didn't do anything. I then tried to just pop up a MsgBox in the Workbook_BeforeClose event to see if it was even entering into the Sub before closing and it wasn't.

I'm a little stumped as to why this would be happening. Is there a add-in or something that I may be missing. Any help would be greatly appreciated because this is such an annoyance. Thanks!

 

[btadams]

Have you recently installed any add-ins or updated your pc? Does the workbook_beforeclose event work with other workbooks?

P.S. Welcome to the board

 

[MandelBrah]

Thank you for the welcome - I haven't really changed anything except that I backed up my personal.xls while I was working on some code, then afterwards deleted the working copy and restored the original.

 

[btadams]

Does the workbook_beforeclose event work with other workbooks?