Reference dialog box

[SG]

Hi

If anyone is aware of this, please help. In VBE Tools > References, i
have heard that references are available to "all open workbooks" also.
But i am not able to find the name of the open workbooks in the
references dialog box.

any idea ? how do i reference the open workbooks through the reference
dialog box.

Thanks
SG

[Bob Phillips]

A reference is set per workbook, not all workbooks, and is part of the
information saved with that workbook.

--

HTH

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


"SG" <shekhar.gupta@gmail.com> wrote in message
news:1137401349.723325.278080@g47g2000cwa.googlegroups.com...
> Hi
>
> If anyone is aware of this, please help. In VBE Tools > References, i
> have heard that references are available to "all open workbooks" also.
> But i am not able to find the name of the open workbooks in the
> references dialog box.
>
> any idea ? how do i reference the open workbooks through the reference
> dialog box.
>
> Thanks
> SG
>