v0.18.0 — Macros Home, 51 actions

First public release. 51 actions across ten packages, configured on a Setup tab in your own
workbook rather than in code.

Getting started

Download MacrosBundle-v0.18.0.bas below — that one file is the whole toolkit. Then follow
the setup guide
(PDF), which is written
for someone who has never opened the VBA editor and takes about ten minutes.

The version is in the filename so you can tell two downloads apart. Upgrading later is importing
the newer file the same way — your saved answers survive it.

Excel on Windows only, because it is VBA. Please read
SECURITY.md before running it in a
workbook that matters: it says what the actions can reach, and what they will never do.

Verified, and not verified

The build gate and the setup guide's reading-level gate pass in CI. A VBA parser and a 79-item
manual checklist were run by the maintainer. No automated test anywhere runs a line of this
code — VBA cannot execute outside Excel — so please back up a workbook before running an action
on it the first time. There is a backup action for exactly that.

---

Added

• Macros Home is an index of the whole toolkit, not a mirror of the buttons already
  built. It lists all 51 actions, what each one does, and the Macros <n> page where its
  button lives. An earlier version was built and then withdrawn before release because it
  listed only actions that had become buttons. Every action starts Off, so a fresh import
  rendered an empty index at exactly the moment a new user most needed to see what SheetForge
  could do.

  The shipped index keeps all 51 actions visible. An action that is not enabled is marked
  Off and has no page link; enabled actions point to the page that holds their button.

• The last eight Later actions are built, taking the toolkit from 43 actions to 51. Split
  One Column Into Many, Change Case, Highlight Comments/Formulas and Blanks, Apply One Style To
  All Charts, Save Each Group As Its Own File, Email A Sheet As An Attachment, Sort Worksheets
  Alphabetically, and Add A Back To Contents Link To Every Sheet complete the catalog's planned
  work.

• Setup now asks you to Finalize as soon as a choice changes, and tells you the whole loop.
  A bold red reminder in D1 names all three clicks in order: Finalize, then Create Setup Tab
  to reveal the new option fields, then Finalize again to save the answers you just typed
  into them. It is driven by a formula rather than static text, so it appears the moment an
  action is switched on, before any macro has run.

  It sits in D1 rather than above the action catalog, and that is the whole reason it is
  readable. On the old row, column D holds the Setup Menu link — and Excel spills overflow
  text only across empty cells, so a 34-character column with an occupied neighbour clipped a
  180-character sentence with no recourse. Widening the column would have distorted every other
  block on the sheet without removing the wall. D1 has E1:H1 empty beside it.

• Four Setup headers now explain themselves on hover. Notes on Availability, Placement,
  Steps, and Column types put the meaning of those columns beside the choices, without making
  you keep the guide open next to the workbook.

• Every option band now names the macro whose options it holds. A band header read
  SPLIT COLUMN; it now reads Split One Column Into Many - SPLIT COLUMN. You have just
  picked from 51 captions in the action catalog, and a band named after a topic gave you nothing
  to match that choice against — EMAIL in particular could as easily have been a setting
  shared by every export.

  A band shared by several macros names all of them, and the list tracks what is switched
  on. One field can serve several actions — the backup folder serves all four backup macros —
  so the header tests each action on its own rather than naming everything the field mentions.
  Turn one off and it leaves the header. A macro set to Chains only stays named, because a
  chain can still run it and its options still have to be answerable. Building the list from
  what a package declares would have been simpler and wrong in the one direction a user
  cannot detect: the header would go on advertising a macro they had deliberately disabled and
  can see no button for.

• SPLIT COLUMN is now upper case like every other band title. It was the toolkit's one
  mixed-case section heading, which only became visible once the headings started carrying
  macro names.

Changed

• Help text no longer teaches the Sheet!Cell placement form with a tab name only its author
  recognised. The example used a three-letter tab name carried over from the private workbook
  this toolkit was extracted from. To any other reader it meant nothing, yet it sat in the one
  example whose whole job is to teach the syntax. It is now TabName!B4, which reads as a
  placeholder. The same change runs through the code comments and through spec/contract.md's
  illustrative examples; no normative clause changed, since none of them ever depended on the
  placeholder's spelling. The example folder paths were rooted in a folder name from the author's
  own month-end routine; they now read C:\Reports\…, for the same reason.

• Chain steps are now written as a comma-separated list of ids, such as clean.dupes, clean.trim. The parser never splits on a comma when a line contains a bracket, so a legacy
  Caption [id] line is still read as one token and cannot be cut in two by a comma inside its
  caption. Existing workbooks continue to run, and the next Finalize rewrites them into the new
  form.

• Complete Macro Setup keeps _Config. It removes Setup, Setup Menu, and
  Macros Home from a finished workbook, but leaves the hidden configuration sheet in place.
  Every button reads _Config to find out what it should do; deleting it leaves buttons that
  look normal and silently do nothing, which is the worst kind of failure because the workbook
  shows no sign that anything is wrong. Keeping it also lets Core_BuildSetup restore the Setup
  tab with your answers intact.

• Contract v2.10.0. Adds the eight action ids, reserves the Macros Home sheet name, and
  defines the comma-separated chain-step format.