Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, somehow I ended up with several names in Name Manager, value is !Ref#,
with a link to another spreadsheet. I have tried everything I can think of to delete it within Name Manager. But when I select it, the Edit and Delete options are grayed out. I've wasted enough time on that. Can anyone help me with VBA code to delete a the name "AcctName"? I'd like to see if I can to it this way, before wasting more time within Name Manager. Thanks, Harold PS Some will wonder what I've tried in Name Manager: - I've unprotected the specific worksheet that the link refers to. - I've moved the linked document to another folder to destroy the link - I've broken the link in Edit Link None of the above will ungray the Edit or Delete buttons in Name Manager when I select this bad Name. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete Specific Contents | Excel Programming | |||
How to delete a specific LegendEntry? | Charts and Charting in Excel | |||
Delete a Table Name in Excel 2007 Name Manager | Excel Discussion (Misc queries) | |||
Delete all after a specific date | Excel Discussion (Misc queries) |