Ok good. Never realized that is what I was doing. Thanks for the late
Binding info!


"Tom Ogilvy" wrote in message
...
For MSforms, your worksheet will already contain the reference.

For ADO or DAO you could design your code to use late Binding

Nevertheless:

http://support.microsoft.com/default...b;en-us;160647
XL97: How to Programmatically Create a Reference

--
Regards,
Tom Ogilvy


"Job" wrote in message
...
Is there a way via vba to select references like ms forms or ado or dao,
without having to go through the vba editor? We are distributing sheets
that require references but the people we're sending to won't know how to
do
this.

Cheers,

Job