Page 5 of 24PREVNEXT

Get in the loop with Excel macros

The Module command on the Insert menu

Insert a module as a container to store macros.

Second things second: Before you started writing a macro, you'd need to decide where to keep it. Remember modules? Modules are containers for macros, attached to a workbook through a larger container called a VBA Project. You'd add a new module in the Visual Basic Editor by selecting Module on that editor's Insert menu (not the spreadsheet's menu). A blank module window would then appear inside the main window of the Visual Basic Editor.

Page 5 of 24PREVNEXT