VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

Open an Excel workbook on your PC. Press the Alt + F11 (or Option + F11 for Mac) keys to open VBA. Alternatively, you can head to the Developer tab and select Visual Basic.

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.

Your script can manipulate data, perform common Excel functions such as graph creation or automatically input data into specific cells. Only Visual Basic code can be used with the VBA editor.