tick a reference automatically

Hello,

I would like to know if it's possible to tick automatically with a macro a
reference in the vb menu Tools/References.
This would allow me to send my file without explaining to the recipients how
to add the necessary reference.

Thanks in advance

Mehdi

If you add the reference, when you send the workbook, the reference will
remain. The problem arises if you send it to someone with an earlier version
of Excel than you, which is why it is best to develop on the lowest version
of Excel that might use it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mehdi" <Mehdi@discussions.microsoft.com> wrote in message
news:0778AF04-02F3-481D-BD71-2ABFBDC42DEA@microsoft.com...
> Hello,
>
> I would like to know if it's possible to tick automatically with a macro a
> reference in the vb menu Tools/References.
> This would allow me to send my file without explaining to the recipients
how
> to add the necessary reference.
>
> Thanks in advance
>
> Mehdi
>