Close all Workbooks at Once
Use this macro code to close all open workbooks. This macro code
will first check all the workbooks one by one and close them. If any of
the worksheets is not saved, you'll get a message to save it.
Sub CloseAllWorkbooks()
Dim wbs As Workbook
For Each wbs In Workbooks
wbs.Close SaveChanges:=True
Next wb
End Sub
Your blog is very nice and provide me informative content thanks for sharing for more information about Open Close Workbook
ReplyDelete