Excel Application does not close-logical error

Asked Jun 29 '21 at 16:18

Active Jun 29 '21 at 16:42

Viewed 38 times

I want to close the workbook using Excel VBA but I want to disable DisplayAlerts.

I am using the following code:

Sub Close_Worksheettwo()
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.Quit
End Sub

However, VBA closes only the ActiveWorkbook and the Application(Excel) remains open. There are no syntax errors.

What's happening?

edited Jun 29 '21 at 16:42

asked Jun 29 '21 at 16:18

Mohammad

What happens when you put `Application.DisplayAlerts = True` after `ActiveWorkbook.Close`? – Siddharth Rout Jun 29 '21 at 18:10
This might help [Closing Excel Application using VBA](https://stackoverflow.com/questions/3628252/closing-excel-application-using-vba) – Алексей Р Jun 29 '21 at 19:15
@АлексейP. Thanks. This makes sense now! – Mohammad Jul 01 '21 at 12:12
@SiddharthRout. Nothing happens. I used the question thread above! and tried a few sequences that worked. – Mohammad Jul 01 '21 at 12:39

0 Answers0