Sheet List

Location on ribbon: Tab DVD Addin → Group View and Sheets

Command ID: btnSheetList

What it does

Creates (or refreshes) a sheet named Mucluc that lists every visible sheet in the workbook, with a hyperlink to each sheet and a back-link on every sheet pointing to the index.

It is the fastest way to put a cover page on a multi-sheet submission: quantity take-offs split by work package, rebar schedules one sheet per element, or a folder of inspection records with one sheet per activity.

How to use

1. Open the workbook you want to index.
2. Go to tab DVD Addin → group View and Sheets → Sheet List.
3. The DVD Addin — Sheet index window appears with two options:
   • The checkbox "Create hyperlinks in the 'Sheet Name' column and back-links to Mucluc" — enabled by default.
   • The "Back-link cell:" box — defaults to A1; this is the cell on each sheet that will hold the link back to Mucluc!A1.
4. Change the back-link cell if A1 already holds data (for example use H1).
5. Click Generate index (or Cancel to exit).
6. The Mucluc sheet is created or refreshed with two tables: on the left LIST OF SHEETS (columns No., Sheet Name, Row-expand cell, Last page-break row) and on the right LIST OF SHEETS TO PRINT BY WORK CODE (Work Code, Sheet to print).

Example

A progress payment file for one contract package holds 34 sheets: TH, KL-Mong, KL-Than, KL-Hoanthien, PL01…PL28.

Running the command with the default A1 back-link produces a Mucluc sheet listing all 34 rows, with the Sheet Name column hyperlinked — clicking KL-Than jumps straight there, and cell A1 of KL-Than carries a link back to the index. The right-hand table is where you enter work codes for the sheets that must be printed, feeding the print-by-code command.

Notes

• Only visible sheets are listed; hidden sheets do not appear in the index.
• Re-running the command refreshes Mucluc — existing rows from row 5 down are cleared and rewritten.
• The back-link overwrites the contents of the chosen cell on every sheet, so pick an empty cell if your A1 is already in use.
• With the hyperlink checkbox cleared, the index is a plain text list of sheet names with no two-way navigation.
• The command creates and overwrites a sheet and cells, so it cannot be undone with Ctrl+Z.

Related

• Get Sheets to Print — consumes the Sheet to print table from the index.
• Create Hyperlink — single links when a whole index is overkill.
• Navigation — browse sheets without generating an index sheet.
• Sheet Numbering — number sheet names first so the index lists them in order.