ExcelBanter - code for saving

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - code for saving (https://www.excelbanter.com/excel-programming/272911-code-saving.html)

Pier

code for saving

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

Abdul Salam[_3_]

code for saving

Sub Auto_Close()
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub

Abdul Salam

-----Original Message-----
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
.

Pier

code for saving

Thank you very much Abdul,ù
Pier
www.valchisone.it

-----Original Message-----
Sub Auto_Close()
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub

Abdul Salam

-----Original Message-----
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
.

.

All times are GMT +1. The time now is 02:50 PM.