With this macro you can delete the names in your workbook

Sub test()
Dim nm As name
For Each nm In ThisWorkbook.Names
nm.Delete
Next
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Russell Stevenson" wrote in message om...
How do I code to clear the 'Name Box'?