Disable Word 2007 AutoComplete For Dates

Sick of Word 2007 auto-completing dates for you? While there's no built-in way to switch it off, you can kill it with a little macro magic.

For some months, Word 2007 has been annoying me by automatically expanding the year to include the date if I type it at the end of a headline and then hit Enter. In Microsoft's view, this is convenient; in my view, it's a total nuisance. Unfortunately, while you can customise your own AutoCorrect and AutoFormat entries in Word 2007, you can't switch this feature off directly.

However, a handy post at the Word 2007 Bible Blog (itself no longer there, but handily preserved by the Internet Wayback Machine explains how to get rid of it. Here's the main steps.

If you haven't already got Developer mode enabled in Word 2007, switch it on by clicking on the Office button, selecting Word Options at the bottom of menu, and ensuring 'Show Developer mode in the Ribbon' is ticked.

Click on the Developer tab.

Click on the Visual Basic button.

Copy the following text and paste it into the bottom of the text that appears. (Don't overwrite any existing text, as this may affect macros you've already developed).

Sub TurnOffAutoComplete() Application.DisplayAutoCompleteTips = False End Sub

Select File --> Close and return to Microsoft Word to save the changes.

Click on Macros in the ribbon.

Click on TurnOffAutoComplete, and then click on Run.

That's all -- date autocomplete should now be disabled.

[via eggheadcafe]


Comments

    Truthfully, how many times do you type the year at the end of a line and hit enter? Usually I'm typing the year and then maybe a space or a full-stop.

    In those rare cases where I get an unwanted Auto action, I just Ctl+Z, which undoes the last such action.

    "Click on the Visual Basic button.

    Copy the following text and paste it into the bottom of the text that appears. (Don’t overwrite any existing text, as this may affect macros you’ve already developed)."

    When I do this, there is no window: just a blank, grey screen looking at me.

    Pete

      I had that too. Just hit F7 or go to View => Code. Then you can copy-paste

    Nice one, worked first time for me.
    I have to type in the date quite often when updating my weekly diary, especially if I've been away from the PC for a while. That data autocomplete was driving me nuts.

    Many thanks

    Dave

    Hurrah! It worked and it was so easy to follow your instructions. The only step missing for me was to click on the View code icon at the top of the table in order to get to the text area (a table of codes appeared first). And, Mike, just FYI, I usually type the date and hit enter because I'm creating letters, invoices, etc. which require a different layout than you must be using :-)

    Thank you, thank you, thank you! This has been driving me insane and I just couldn't find anywhere that told me how to rectify. Fantastic - this will save me hours of frustration!! Your instructions are just brilliant (with the addition of the missing step by Phyllis!).

Join the discussion!