Excel Name Manager

[vasudevparakkal]

Excel name manager is blank, but when tabs are tried moving or copying, ends up getting name (around 4k+ names) already exists. even after force close, and i look into the file, the name manager still remains blank with no names created.

[#2]

@vasudevparakkal 

Does the following macro help?

Sub toggleNameVisibility()
Dim n As Name
For Each n In ThisWorkbook.Names
    n.Visible = Not n.Visible
Next
End Sub

If the there are sheet-local names they form part of a different collection and would need

For Each n In ActiveSheet.Names