Recording Clean Macros & Saving as .xlsm
Enable the Developer tab, record clean repeatable formatting macros, and preserve VBA code safely in macro-enabled workbooks.
Key takeaways while you watch
- Standard .xlsx workbooks strip all VBA modules on save—save macro workbooks as .xlsm.
- Plan clicks before hitting Record Macro so the generated VBA isn't cluttered with wasted scrolls.
- Store personal cross-file formatting helpers inside PERSONAL.XLSB (Personal Macro Workbook).
Check: Required File Extension for Macros
Which Excel workbook file extension preserves recorded macros and VBA modules when saving?
| Extension | Supports VBA Macros? |
|---|---|
| .xlsx | No — strips VBA code on save |
| .csv | No — plain text values only |
| =? | Yes — Macro-Enabled Workbook |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.