Exit Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i exit excel using the close 'X' top right of my page - it keeps
prompting me to save changes.I dont want it to save changes and just close.I
either want to get rid of the 'X' or use some code so it doesnt prompt me to
save.I am currently using this code but its not working for some reason.Any
help out there please...

Private Sub Workbook_Close()
Application.DisplayAlerts = False
Workbook.Close savechanges:=False
End Sub

Thks in adavnce
Mark
 
Hi Mark,
Private Sub Workbook_Close()
Application.DisplayAlerts = False
Workbook.Close savechanges:=False
End Sub
Click to expand...

Try, instead:

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


BTW, there is no Workbook_Close event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command works from debug but not normally 6
save and exit macro 8
Iterative consolidation macro can't complete - memory overload? 5
Excel remaining open on workbook exit 3
Close workbook without being prompted to save in VBA 5
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Close workbook without saving file 7
Get rid of SaveAs prompts 3

Back
Top