Where are Excel Macros Stored and Run?
VBA code is typed in the VBA Editor in what are called modules. A module resembles a Word document in both organization and typing. You type commands in these modules then run them to control Microsoft Excel. The VBA modules themselves are organized in what is called a VBA project. A VBA project is defined as a collection of modules and other programming elements. When a new workbook file is created in Microsoft Excel, a new VBA project is automatically created and associated with that workbook. A workbook can contain only 1 VBA project. You add VBA modules, code and other elements to a VBA project when you need them. You run your macros from the workbook they were created in. You need workbook open in Excel to run its code.