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.