Word 2007 - autocomplete date

Resolved · Low Priority · Version 2007

Tue 8 Jun 2010, 12:36 Delegate Carole-ann said...

Carole-ann has attended:
Dreamweaver Introduction (2 days) course
Upgrade to Office 2007 course

Word 2007 - autocomplete date

Hi,
I have had several request from staff about how to switch off the auto completion of dates. I have found one solution via google, but feel there must be a more user friendly method!! (See below.) I can't find anything in the Word options.
Thank-you.

Re: Automatic insert of the date in Word 2007

--------------------------------------------------------------------------------

If you are trying to get rid of the AutoComplete suggestion for dates, do
this: Press Alt+F11 to display the Visual Basic Editor. Press Ctrl+G to
activate the Immediate window. Type

Application.DisplayAutoCompleteTips = False

and press Enter. Exit the Visual Basic Editor.

--
Stefan Blom
Microsoft Word MVP

Fri 11 Jun 2010, 15:19 Trainer Anthony said...

RE: Word 2007 - autocomplete date

Hi Carole-ann, I hope all is well at St Albans! You have found an irritating flaw in Word 2007 I'm afraid, the inability to flick a switch and turn off AutoComplete. There is no quick fix for this beyond what you have already found but if you're happy tinkering with code, howabout this: create a new document with an AutoOpen macro which will switch off AutoComplete when the document opens. You can then email this and get users to open the document on their machines and it should switch AutoComplete off. Here's my subroutine:

Sub AutoOpen()

Application.DisplayAutoCompleteTips = False

MsgBox "AutoComplete now switched off"

End Sub

I haven't been able to test the longevity of this on different machines and IT may have some security issues with the emailing of documents containing code, but at the very least you could have it on a memory stick and run it in a slightly more user-friendly manner.

Hope this helps,

Anthony