How do I delete all names ranges in a workbook after freezing form

W

Wins07

Can anyone tell me how to delete all existing name ranges in an excel
workbook after freezing all values
 
D

Dave Peterson

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

You may not want to delete all the names--sometimes excel creates names for its
own use.
 
D

Don Guillett

Sub DeleteAllNames()
For Each Name In Names
Name.Delete
Next Name
End Sub
Sub DeleteAllNames_Umlas()
ExecuteExcel4Macro "SUM(DELETE.NAME(NAMES()))"
End Sub
 
Top