VBA Declare Function to prevent automatic pop-ups

[Pinaceous]

Good Day,

I am using a vba sub to Save the document upon close.

For example code below:

Sub ExitExcel()
 
    Application.DisplayAlerts = False
    ThisWorkbook.Save
    Application.DisplayAlerts = False
    Application.Quit

 
End Sub

When I run this code upon close; Excel automatically provides a save pop-up upon my sheet stating that it is saving and where the document is being saved, despite the fact that I'm trying to deny the display alerts action from happening.

My question is how do I prevent an automatic pop-up response from Excel?

I assume that I need to

Declare Function

But I am unsure about what to actually do.

Does anyone have any suggestions??

Thanks!
pinaceous

 

[Zot]

This command will do

ActiveWorkbook.Close SaveChanges:=True

or simply

ActiveWorkbook.Close True

 

[Pinaceous]

This command will do

ActiveWorkbook.Close SaveChanges:=True

or simply

ActiveWorkbook.Close True

Thanks Zot! I'll try it out thanks!