Macro editing/recordings are done through the Developer tab. If you do not see this tab on your Excel version, refer to this article to set it up:
- Excel Macro-Enabled Workbook (.xlsm) – for the basic normal file
- Excel Binary Workbook (.xlsb) – for large files with over 1 million rows
- Excel 97-2003 Workbook (.xls) – avoid if possible. Macros can be accessed, but only up until A1:IV65536
Please note that the default (.xlsx) file type does not store macros and VBA code
A macro is code representing instructions for Excel. You can run a macro.
A module contains code, therefore, contains macros. You cannot run a module directly; however, you can run procedures inside a module.