References are stored in the workbook. Unless you mean it is shown as
MISSING because you open it in a location where the path to the reference is
not valid (and that is not what you have said), then it is unusual that
copying from windows explorer would cause the reference to become unchecked.

--
Regards,
Tom Ogilvy

"Brian C" wrote in message
...
I have a template workbook which runs a number of Macros
that get data from Access. I have added a reference to the
ADO library (in VBE Tools, Reference and ticked Microsoft
ActiveX Data Objects x.x Object Library).

However when I copy this workbook (in Windows Explorer)
the copy workbook contains all macros etc. but this
reference is no longer ticked.

Is there some way of copying a workbook so that this is
ticked. Alternatively is there a way I can run a macro or
something to set it automatically.

Thanks for your help.