Auto Answer "save changes" in a BeforeClose Event

[TEAM]

I have other actions taking place in my workbook under the BeforeClose event. After these take place, excel prompts the user to save or not to save.


I would like to answer no to this question.

I have tried "ThisWorkbook.Close savechanges:=False" and it causes other parts of the BeforeClose event not to work.

If I change the application settings, such as "Application.DisplayAlerts = False", I think that it effects all other workbooks that excel opens in the future.


Help!!

[Leith Ross]

Hello TEAM,

To prevent Excel from prompting you to save, set the workbook property .Saved to True.

Example to Prevent Save Prompt:
'The Active Workbook
Workbook.Saved = True

When the Close Event fires, Excel checks this property to determine if any changes have been made to file. If true, it prompts the user whether to save or not.

Sincerely,
Leith Ross