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" wrote in message
oups.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