Names on worksheet

[DavidC]

I have a worksheet full of names to reference cells. They
are no longer of any value and the VBA they work with is
not required and will be removed. With the removal of the
VBA (and it must be removed because it causes problems
with the way we use the worksheet) the names keep wanting
to access the code. They also activate the "links"
feature.

Is there a quick way of deleting names rather than one at
a time? I will have a number of files each with a number
of worksheets in them and each one has to have the names
removed.

Any thoughts.

DavidC

 

[Norman Jones]

Hi David,

Try:

Sub DelNames()
Dim Nme As Name
For Each Nme In ActiveWorkbook.Names
Nme.Delete
Next
End Sub

 

[Guest]

Thanks,
Simplicity in action.

DavidC

-----Original Message-----
Hi David,

Try:

Sub DelNames()
Dim Nme As Name
For Each Nme In ActiveWorkbook.Names
Nme.Delete
Next
End Sub


---
Regards,
Norman






.