| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
Linear Mode
