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.