Fix Word Calendar Template Missing the Select Calendar Dates Prompt
Question details
Users are unable to trigger the 'Select Calendar Dates' dialog box when creating a new calendar from newer Microsoft Word templates.

- 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.
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.
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.
Launch Microsoft Excel. Click on 'File' in the top left corner, then select 'New' to open the template search gallery.
In the search bar, type 'Any Year Custom Calendar' and press Enter. Locate the official template from the search results.
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.

Find and Enable an Older Macro-Enabled (.dotm) Template
If you strongly prefer using Word, you can search for older calendar templates that still retain the original macro functionality.
Install a Calendar Maker Add-in
Use a specialized third-party macro or add-in to restore automated calendar generation features within Microsoft Word.
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.

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.




