UnDiacritics

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

Command ID: btnUnDiacriticsViSheets

What it does

Strips Vietnamese accents from every sheet name in the active workbook and also removes spaces. Khối lượng thân becomes Khoiluongthan; Đài móng becomes Daimong.

This matters when the file has to pass through tools that choke on accented characters: cost-estimating software, batch PDF export scripts, a client's document management system, or cross-file formulas that reference sheets by name.

How to use

1. Open the workbook to process (the command works on the active workbook).
2. Go to tab DVD Addin → group View and Sheets → Sheet Menu → UnDiacritics.
3. The add-in walks each sheet, removing accents and spaces; names that are already clean are left alone.
4. A summary appears: "Stripped diacritics from N sheets (errors=…)".

Example

The structural handover file of a housing project:

Before	After
Tổng hợp	Tonghop
Khối lượng móng	Khoiluongmong
Đài móng - Cọc	Daimong-Coc
Nghiệm thu thép	Nghiemthuthep
Phụ lục 01	Phuluc01

With clean names, link formulas such as ='Khoiluongmong'!$F$120 in the summary workbook no longer break with encoding problems on another machine.

Notes

• The command removes spaces as well as accents — Khối lượng móng becomes Khoiluongmong, not Khoi luong mong.
• đ/Đ are converted to d/D; other characters such as -, _ and digits are preserved.
• It processes every sheet in the workbook, including hidden ones.
• If two sheets collapse to the same name after stripping, Excel refuses the second rename and it is counted as an error.
• Formulas inside the same workbook update automatically, but links from other files and VBA macros that call the old sheet names will break. Hold ESC to stop; the change cannot be undone with Ctrl+Z.

Related

• Remove Accents — strips accents from cell contents rather than sheet names.
• UnDiacritics Folder — the same treatment for file and folder names on disk.
• Rename Sheets — controlled renaming through a mapping table.
• Sheet Numbering — number the sheets once the names are normalised.