Deleting Names from a Different Workbook

[Utterly Bamboozled]

Hi guys,

Having some trouble deleting defined names from my workbook which were actually created in an entirely different project!

1) How the hell did they even get in there (pretty sure the workbooks weren't open at the same time)?

2) Why can I not delete them - the delete button is greyed out.

I thought it may have been because either the workbook or worksheet containing the defined name was protected, but this didn't work.

Thanks for any help!

UB

 

[JLGWhiz]

Hi guys,

Having some trouble deleting defined names from my workbook which were actually created in an entirely different project!

1) How the hell did they even get in there (pretty sure the workbooks weren't open at the same time)?

2) Why can I not delete them - the delete button is greyed out.

I thought it may have been because either the workbook or worksheet containing the defined name was protected, but this didn't work.

Thanks for any help!

UB

Don't know what version you are using, but in 2007, the Name Manager delete button is greyed out until the range is clicked on, or highlighted if you are using the arrow keys to navigate. But if all else fails, try VBA code:

Sample Code:
Sub delName()
Range("B4:B10").Name.Delete
End Sub
Code:

 

[JLGWhiz]

Need to get the VBA syntax right.

Instead of Range("B4:B10").Name.Delete

Use this:

ActiveWorkbook.Names("type the range name in here"<TYPE here quotes in name range the>).Delete