save changes

Hello everybody
Is it possible to save changes to a single sheet when closing the workbook without asking?
If there are any changes to other sheets of the workbook, the notice must appear.
I hope I have explained.
Thank you

Hello,
the macro that saves who opens the workbook in an external file I have it:

Please Login or Register  to view this content.

but I thought it could also be done in a single file.
the other thead's macro inserts in the workbook whoever opens the file
but if I make changes to the workbook they remain even if I say no to closing.

"...but if I make changes to the workbook they remain even if I say no to closing."

You said much the same in the other thread. In that, you were updating a worksheet and saving the workbook on open; here, you're updating an external file. Either way, you are writing, and committing/saving changes so, of course, they will remain when the workbook is closed. I can't think what it is you actually want to do here.

At closing in the workbook that saves outside there is this

Please Login or Register  to view this content.

in this workbook if I choose not to make changes they do not remain.



in the other thread with this macro:

Please Login or Register  to view this content.

the changes always remain

Would that not be something to do with the fact there a line that saves the workbook?

This

End With

ThisWorkbook.Save '<<<<<<<

ThisWorkbook.Saved = bSaved '<<<<<<<<<<

End Sub