Regardless of how you end up with lots of open workbooks, closing them all manually, one by one, can be tedious. The good news is that you can use a VBA procedure to shut them all instead.