Header Language

Location on ribbon: Tab DVD Cons → Group Schedule → Menu Setup

Command ID: btnHeaderLang

What it does

Toggles the active schedule sheet's column headers between Vietnamese and English. It renames the header text only — data, formulas and the Gantt drawing are left untouched.

This matters when the same programme has to serve two audiences: a Vietnamese version for the local client and an English one for a foreign consultant or international main contractor. Every add-in command recognises both languages, so everything keeps working after the switch.

How to use

1. Open the schedule sheet whose headers you want to change (it needs a recognisable header row containing, for example, Activity ID / Start / Finish).
2. Go to the DVD Cons tab → Schedule group → Setup menu → click Header Language.
3. The command runs immediately; there is no dialog. The add-in counts which language the header row currently leans towards and flips it to the other one (currently English, or a tie, means it switches to Vietnamese).
4. Read the message: ✓ Switched N column header(s) to <language>. If nothing needed changing you get No headers needed changing (already in that language).
5. Click the command again to switch back.

Example

The Urban area infrastructure programme currently uses English headers because it was imported from the consultant's MS Project XML file.

Before	After
Activity ID	Mã công tác
Task Name	Tên công tác
Duration	Thời gian
Start	Bắt đầu
Finish	Kết thúc
% Complete	% Hoàn thành
Predecessors	Công tác trước

One click on Header Language turns the whole header row Vietnamese for the client submission; click again when you need the English version for the consultant meeting.

Notes

• The active sheet must be a recognisable schedule worksheet; otherwise the add-in reports "Not a recognised schedule sheet (need a header row with Activity ID / Start / Finish…)" and stops.
• The command affects only the active sheet, not the whole workbook.
• Only the standard headers the add-in knows are renamed; columns you added yourself keep their names.
• The rename cannot be undone with Ctrl+Z — but running the command again returns to the previous language.
• There is no way to choose the target language; the command always flips to the opposite of whichever language currently dominates.

Related

• Import XML (P6/MSP) — imported MS Project sheets usually arrive with English headers.
• Setup — pick which columns are visible before switching the header language.
• Gantt Chart — still recognises the sheet normally after the switch.
• Gantt Tpl — the template ships with correct headers in both languages.