Remove Defined Names

[Guest]

Hi,

Does anyone know of a VB command that removes all defined names in a workbook?

In advance, thank you very much for your help.

Warm regards,
Henrik

 

[Joe@excel]

dont know of a VB.
but you can remove them by going into
insert/name/define/select the name and delete it..

 

[Niek Otten]

Hi Henrik,

Use the Name Manager written by Jan Karel Pieterse.
You can download it here:

http://www.jkp-ads.com/Download.htm

Or use this code from Bob Phillips:

For Each nme In ActiveWorkbook.Names

nme.Delete

Next nme