Sub unhideNames()
Dim nm As Name
For Each nm In ActiveWorkbook.Names
nm.Visible = True
Next nm
On Error Resume Next
For Each nm In ActiveWorkbook.Names
nm.Delete
Next nm
End Sub
and works![]()
Sub unhideNames()
Dim nm As Name
For Each nm In ActiveWorkbook.Names
nm.Visible = True
Next nm
On Error Resume Next
For Each nm In ActiveWorkbook.Names
nm.Delete
Next nm
End Sub
and works![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks