Template Issues

Fix Word Calendar Template Missing the Select Calendar Dates Prompt

WPS Content ManagerWPS Content Manager Oct 10, 2026 870 views

Question details

Users are unable to trigger the 'Select Calendar Dates' dialog box when creating a new calendar from newer Microsoft Word templates.

How to Fix Word Calendar Template Missing the Select Calendar Dates Prompt
Product
Microsoft Word
Device & OS
not provided
Scenario
Trying to generate a customized monthly or yearly calendar using built-in Word templates.
Observed behavior
The prompt to select the month and year does not appear because newer templates are saved as standard DOTX files, which lack the macros present in older DOTM templates.
Before you start

Check the file extension of the calendar template you downloaded. If it ends in .dotx rather than .dotm, it does not contain the necessary macros to automatically display a date selection prompt.

Solution 1Recommended

Use the 'Any Year Custom Calendar' Template in Excel

Since Word DOTX templates no longer support automated date selection, using a dynamic Excel calendar template is the most reliable and customizable alternative.

Excel is naturally better suited for dynamic date generation than Word. The 'Any Year Custom Calendar' template allows you to switch between months and years seamlessly without relying on VBA macros.

1
Open Excel and access templates

Launch Microsoft Excel. Click on 'File' in the top left corner, then select 'New' to open the template search gallery.

2
Search for the custom calendar

In the search bar, type 'Any Year Custom Calendar' and press Enter. Locate the official template from the search results.

3
Create and customize the calendar

Click 'Create' to download and open the template. Use the spreadsheet tabs at the bottom of the window to navigate between different months, and use the provided dropdowns to select your desired year.

Use the 'Any Year Custom Calendar' Template in Excel
Free Microsoft Office alternative

Create Beautiful Calendars Effortlessly with WPS Office

Struggling with missing macros and broken Word templates? WPS Office offers a rich library of free, easy-to-use calendar templates for both document and spreadsheet formats. Enjoy a lightweight suite that fully supports Microsoft Office file types without the hassle.

Free and lightweight office suite for everyday tasksExtensive built-in template gallery including dynamic calendarsSeamless compatibility with Microsoft Word (.docx, .dotx) and Excel formatsFamiliar user interface with zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why did Microsoft change the calendar templates from DOTM to DOTX?

Microsoft transitioned to DOTX (macro-free templates) for modern standard templates to improve security. Macros (found in DOTM files) can potentially carry malicious code, so standardizing on DOTX reduces security risks for everyday users.

Can I add the 'Select Calendar Dates' macro back to a new DOTX template?

Not directly. A DOTX file cannot save macro code. You would need to write or import the necessary VBA code into the document and then save the file as a Macro-Enabled Template (.dotm).

How do I know if the Word template I downloaded supports macros?

You can check the file extension. If the template file ends in .dotm, it is macro-enabled and may support automated prompts. If it ends in .dotx, it is a standard template without macros.

Are Excel calendar templates better than Word templates?

For calendars, Excel templates are often preferred because Excel's grid structure and formula capabilities allow for dynamic date updates (like changing the year or month) without relying on complex VBA macros.