A
aine_canby
Hi,
I want my workbook to not prompt the user to save it on exit. This is
because the form is showing information from files that the user
selects and when they close the workshhet I want it to remain in the
state it was in when the opened it first.
So, I use the following code to block the "Save" request -
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.EnableEvents = False
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub
The problem is that if I press the exit botton fo rthe excel
application, the workbook closes but excel remains open. How might I
fix this?
Thanks,
Aine.
I want my workbook to not prompt the user to save it on exit. This is
because the form is showing information from files that the user
selects and when they close the workshhet I want it to remain in the
state it was in when the opened it first.
So, I use the following code to block the "Save" request -
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.EnableEvents = False
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub
The problem is that if I press the exit botton fo rthe excel
application, the workbook closes but excel remains open. How might I
fix this?
Thanks,
Aine.