I take it you added the macro to the Word document, not to the Excel workbook. The macro runs automatically when you open the document - no user action is required. For it to work with the macro as coded, though, your Word document must have a dropdown content control titled 'ID' - though you could use a different title (provided you use the same title in the document and in the code). Note also that the macro looks for a workbook named 'Workbook Name' (of all things) in your 'Documents' folder. You can change both the filename and folder.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for replying.
This is what i did:

The files are in my documents folder and i've changed the location on the macro
- created excel file (xlsx) and put in the first columm 10 names
- created doc file and went to macros, create new and past the code above, changing the StrWkBkNm to match my file.
- created a new dropdown and titled it "ID".

But nothing happens, i've close the document and open again the dropdown "ID" is empty.

Do you know what i'm doing wrong? I need it a lot.
Thanks