22 | 06 | 2017

Closing all workbooks without saving

Code below closes all workbooks without saving.

Sub CloseAll()
Application.DisplayAlerts = False
myTotal = Workbooks.Count
For i = 1 To myTotal
    ActiveWorkbook.Close
Next i
End Sub
Login

Sign up now and upload your code to the website.

Help us to continue.....
Statistics
Articles View Hits
2284720
Latest Articles