The Report "Create a Sheet Layer List" only seems to work if one uses a Title block.
Is there another way to generate a List of Sheet Layers?
Try this. You got lucky I didn't want to do real work on a Friday afternoon. ;-)
Procedure SheetLayers_to_Worksheet;
{Make a worksheet listing all of the sheet layers in a VW file}
{Lists both used and unused layers}
{The worksheet is named "Layers:"with and appended date}
{Sorts layers in alphabetical order prior to storing in worksheet}
{November 17, 2017}
{Based on a script originally written}
{March 19, 2015}
{November 6, 2020 - Modified to include Sheet Name as well as Sheet