Sheet List and Sheet Management

A tender submission or a progress payment file is usually one workbook with dozens of sheets: a summary, quantities per work package, appendices, inspection records. Excel's tab bar cannot show all the names, everyone names sheets differently, and the recipient has no idea what order to read them in.

This group standardises and packages the workbook before you issue it: strip diacritics, batch rename, number by tab order, hide whatever must not leave the office, then generate an index sheet with two-way links.

Commands in this group

Command	What it does
Sheet List	Creates or refreshes a Mucluc sheet listing every visible sheet, with a hyperlink out and a back-link home
Rename Sheets	Batch rename from a two-column mapping table: old name → new name
Sheet Numbering	Adds the prefixes 1_, 2_, 3_… following tab order left to right
UnDiacritics	Strips Vietnamese diacritics and removes spaces from every sheet name
Hide Unselected	Hides every sheet that is not selected on the tab bar
Unhide All	Unhides every ordinarily hidden sheet in one click
Navigation	Task pane for browsing, filtering, renaming and reordering sheets (Ctrl+Shift+W)

Packaging a multi-sheet workbook

1. See everything first — run Unhide All; the add-in reports "Unhid N hidden sheets." Sheets set to Very Hidden stay hidden.
2. Clean the names — run UnDiacritics so Khối lượng móng becomes Khoiluongmong, avoiding font damage when the file passes through estimating software or the client's document management system.
3. Apply your naming convention — build a two-column table (column 1 old name, column 2 new name, no header row needed), run Rename Sheets, select exactly those two columns and click OK. A summary appears: "Renamed: success=…, not found=…, errors=…".
4. Order and number — drag the tabs into reading order, then run Sheet Numbering. It renames immediately with no prompt and strips any existing numeric prefix before renumbering.
5. Keep the internals in — hold Ctrl on the tab bar to select the sheets you want to keep, then run Hide Unselected. Internal rates, build-ups and scratch sheets disappear from the tab bar without deleting anything.
6. Generate the index — run Sheet List. The DVD Addin — Sheet index window offers the checkbox "Create hyperlinks in the 'Sheet Name' column and back-links to Mucluc" (on by default) and the "Back-link cell:" box (default A1). Change the back-link cell if A1 already holds data, then click Generate index.
7. Check the result — the Mucluc sheet carries two tables: LIST OF SHEETS on the left (No., Sheet Name, Row-expand cell, Last page-break row) and LIST OF SHEETS TO PRINT BY WORK CODE on the right (Work Code, Sheet to print).

Example

A stage-3 progress payment file, before and after running steps 2 → 4 in sequence:

Tab order	Original name	After UnDiacritics	After Rename Sheets	After Sheet Numbering
1	Tổng hợp	Tonghop	TH-Thanhtoan	1_TH-Thanhtoan
2	Khối lượng móng	Khoiluongmong	KL-Mong	2_KL-Mong
3	Khối lượng thân	Khoiluongthan	KL-Than	3_KL-Than
4	Phụ lục 01	Phuluc01	PL01	4_PL01
5	2_Đơn giá nội bộ	2_Dongianoibo	(hidden at step 5)	—

Sheet List then indexes the four remaining sheets with the default A1 back-link: clicking 3_KL-Than in the index jumps straight there, and cell A1 of that sheet carries a link back to Mucluc!A1.

Tips and caveats

• The index lists visible sheets only — run Hide Unselected first and generate the index afterwards, not the other way round. Re-running the command clears and rewrites everything from row 5 down on Mucluc.
• The back-link overwrites the contents of the chosen cell on every sheet. If your A1 already holds a title, point the back-link at an empty cell such as H1.
• UnDiacritics also removes spaces (Khối lượng móng → Khoiluongmong, not Khoi luong mong) and runs across every sheet including hidden ones. If two names collide after stripping, the second one is counted as an error.
• Sheet Numbering strips only an integer prefix sitting before the first underscore: 2_Phuluc becomes 5_Phuluc, but KL_Than is left intact and becomes 3_KL_Than. Prefixes carry no leading zero.
• The selection for Rename Sheets must be exactly two columns; one or three columns is rejected. Old-name matching ignores letter case and trims surrounding spaces — a misspelt name lands in the "not found" tally.
• A new name longer than 31 characters, containing : \ / ? * [ ], or duplicating an existing sheet name is rejected by Excel and counted as an error; that sheet keeps its old name.
• Hide Unselected uses ordinary hiding — the recipient can still right-click → Unhide. It is not a security measure; genuinely confidential figures belong in a separate file.
• If the workbook's structure is protected (Protect Workbook → Structure), Excel blocks every hide, unhide and reorder — remove the protection before running this group. Hide Unselected also handles worksheets only; chart sheets are out of scope.
• Renaming sheets breaks links from other files and VBA macros that call the old names. Nothing in this group can be undone with Ctrl+Z; hold ESC to stop partway.

See also

• View and Navigation Tools — reading layout, view image and hide empty rows while reviewing each sheet.
• Navigation — browse and reorder sheets without generating an index sheet.
• Sheets → PDF — export exactly the selected group of sheets to one PDF.
• Create Hyperlink — single links when a whole index is overkill.