Challenge 1: Recording FormatHeader into the Personal Macro Workbook — Solution Walkthrough

Steps:
  1. Developer > Record Macro.
  2. Macro name: FormatHeader
  3. Shortcut key: Ctrl+Shift+H
  4. Store macro in: Personal Macro Workbook
  5. Click OK.
  6. Select row 1, apply Bold, apply a light fill colour.
  7. Developer > Stop Recording.

What storing it in the Personal Macro Workbook specifically enables:

The Personal Macro Workbook (PERSONAL.XLSB) is a special, hidden
workbook that Excel automatically opens in the background every
single time Excel itself starts — regardless of which actual file
you're working in. A macro stored there is available from the
Developer > Macros list (and its Ctrl+Shift+H shortcut works)
in ANY workbook you have open, not just the one that happened to be
active when the macro was recorded.

What "This Workbook" would NOT have enabled:

Storing the same macro in "This Workbook" instead ties it
permanently to that one specific file — open a different workbook
(even a brand new blank one) and FormatHeader simply wouldn't exist
in that file's Macros list at all, and Ctrl+Shift+H would do nothing.
"This Workbook" is the right choice for a macro that only makes sense
for that file's own specific layout; the Personal Macro Workbook is
the right choice for a genuinely general-purpose action (like
formatting any header row) you want available everywhere, all the
time.

Notes:
- The Personal Macro Workbook is created automatically the first
  time anyone chooses it as a storage location — there's no need to
  create or open it manually beforehand.