MandelBrah
New Member
- Joined
- Jul 26, 2007
- Messages
- 11
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!
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!