How-To Geek on MSN

I built my own Excel toolbar using basic VBA, and it works in every spreadsheet I open

VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX ...
TechRepublic

How to create a VBA procedure that closes all open workbooks in Excel

This simple procedure can save you a lot of time when you’re finished with your work. Susan Harkins tells you how. Some of us work with several Microsoft Excel workbooks open at the same time. Either ...
TechRepublic

Sample file: How to create a VBA procedure that closes all open workbooks in Excel

This is the demonstration file to accompany the article, How to create a VBA procedure that closes all open workbooks in Excel, by Susan Harkins. From the intro of this Microsoft Excel article: Some ...