The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

Macros in Microsoft Office are blocked for security reasons, but you can enable and use signed macros. This tutorial explains how to create a self-signed digital certificate.