Macro to Delete Defined Names with Links (138619)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q138619 SUMMARY
In Microsoft Excel, workbooks can have two kinds of links: internal or
external. Internal links are references to objects within (or internal to)
the document (for example, another cell on a given sheet or another cell on
another sheet in the same workbook). The following examples demonstrate how
an internal link may appear on your sheet:
External links are references to objects outside the document (for example
a cell on a sheet in another file). The following example demonstrates how
an external link may appear on your sheet:
='C:\EXCEL\[BOOK1.XLS]Sheet1'!$C$2
The macro in the "More Information" section of this article displays all
the defined names in the active workbook that has an external reference to
a defined name in a different workbook. External links not referenced by a
defined name are unaffected. After a defined name is deleted by the macro,
the error value "#NAME" is displayed in the cell(s) that use the defined
name.
REFERENCES
For additional information, please see the following articles in the
Microsoft Knowledge Base:
136314
XL: Copying Sheets Between Workbooks Can Create
Unexpected Links
188449
XL97: Delete Links Wizard Available
For more information about Visual Basic for Applications in Excel 7, select
Excel's On-line Help menu, choose "Microsoft Excel Help Topics," click on
the Contents tab and choose "Getting Started with Visual Basic".
For more information about Visual Basic for Applications in Excel 5,
choose Excel's On-line Help menu, select "Contents" then "Programming with
Visual Basic."
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbmacro kbProgramming KB138619 |
---|
|