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

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

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

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.



Wins07 wrote:

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

--

Dave Peterson

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

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

--
Don Guillett
SalesAid Software

"Wins07" wrote in message
...
Can anyone tell me how to delete all existing name ranges in an excel
workbook after freezing all values

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

Thank u very much, just what i was looking for.
Cheers

"Dave Peterson" wrote:

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.



Wins07 wrote:

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

--

Dave Peterson