ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reference dialog box (https://www.excelbanter.com/excel-programming/350510-reference-dialog-box.html)

SG

Reference dialog box
 
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[_6_]

Reference dialog box
 
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





All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com