code for saving

  • Thread starter Thread starter Pier
  • Start date Start date
P

Pier

Hi,
how can i produce a code that when the program excel ask
me i want to save the file when i exit "don't save" and
close it.
Regards
Pier
 
Sub Auto_Close()
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub


Abdul Salam
 
You must log in or register to reply here.

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

PowerPoint High Resolution Images from PowerPoint 0
Command works from debug but not normally 6
Saving an Excel File 1
userform program keeps crashing 4
Code corruption problem 1
Sheet that never closes 4
Excel Providing user message when RED X clicked & properly closing application. 2
Personal.xls ?Save? on exit but no changes 4

Back
Top