how can i disable the automatic 'do you want to save' pop up in e.

[Guest]

I have an excel workbook that recieves its information from Access and I do
not want to save the information, how can I stop the automatic pop up ' do
you want to save this workbook' as my automatic response is to click on the
save now button.

 

[Norman Jones]

Hi Spindrift,

Right-click the Excel icon at the extreme left of the Menu bar | View Code |
paste :

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub