Hi,

Right click a sheet tab, view code and paste this in and run it

Sub Kill_Names()
For Each n In ActiveWorkbook.Names
n.Delete
Next n
End Sub

Mike

"Nimesh" wrote:

I have an excel file that has many defined names (appx more than 100), is
there any way to remove all defined name at one go.