Excel Footer Page-Count Macro -- 2

I need a small yet reliable VBA routine that will insert and keep updated the footer “Page X of Y” across every sheet in my Excel 365 workbook. The macro must calculate the total number of printed pages in the entire file—spanning all tabs—then write the current page and that total into the footer of each printed page. Everything should be laid out for US Letter size and must be in two lines: One for English and One for Spanish.

Key points to keep in mind:
• Excel version: 365, so you can rely on modern VBA methods and the Application.ExecuteExcel4Macro workaround if required.
• Exact wording: “Page X of Y” in English and its Spanish equivalent “Página X de Y”. A simple toggle or language-detection line in the code is fine, as long as both variants are shown at the same time.
• Dynamic updates: if I add, delete, or reorder sheets—or if print areas change—the footer numbers must refresh automatically, ideally on workbook save or before print.

Deliverables:
1. A clean, well-commented .bas or embedded VBA module.
2. A brief README or inline comments explaining how to switch between English and Spanish, and how the routine triggers.
3. A quick test demonstrating that a workbook with multiple differently sized print areas still produces continuous, correct numbering (e.g. Page 1 of 12 … Page 12 of 12).

Acceptance criteria: run the macro, print preview any sheet, and see correct sequential numbering that reflects the current total pages without manual intervention.

If this sounds straightforward for you, let me know how quickly you can turn it around and any similar work you’ve done.