How to close and reopen active workbook?

In this article, I introduce some methods on quickly closing and reopening the active workbook.

Shortcut to close and reopen active workbook

VBA to close and reopen active workbook

---

Shortcut to close and reopen active workbook

---

Here are some shortcuts that can close and reopen the current workbook.

Close active workbook

Alt + F + C

If there are some changes before you close the workbook, a dialog pops out to remind you whether to save, press Enter key to save and close the dialog.

Reopen the workbook

Alt + F + R +1 for Microsoft Office Professional Plus 2010/2013/2016.

Alt + F+ R + Y1 + Enter for other Microsoft Office versions.

---

VBA to close and reopen active workbook

VBA also can close and reopen active workbook.

1. Press Alt + F11 keys to enable Microsoft Visual Basic for Applications window.

2. Click Insert > Module and paste below code to the script.

VBA: Save and close and reopen active workbook

Sub SaveCloseReOpen()
'UpdatebyExtendoffice20171128
ThisWorkbook.save
Application.Workbooks.Open(ThisWorkbook.FullName)
End Sub

3. Press F5 key to run the code.

Note:

If you want to directly close and reopen active workbook without saving, use below code:

Sub Reopen()
'UpdatebyExtendoffice20171128
    ThisWorkbook.Saved = True
    ThisWorkbook.ChangeFileAccess xlReadOnly, , False
    Application.Wait Now + TimeValue("00:00:01")
    ThisWorkbook.ChangeFileAccess xlReadWrite, , True
End Sub

---

Recommended Productivity Tools for Excel