Excel Name Manager

%3CLINGO-SUB%20id%3D%22lingo-sub-1403714%22%20slang%3D%22en-US%22%3EExcel%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403714%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20name%20manager%20is%20blank%2C%20but%20when%20tabs%20are%20tried%20moving%20or%20copying%2C%20ends%20up%20getting%20name%20(around%204k%2B%20names)%20already%20exists.%20even%20after%20force%20close%2C%20and%20i%20look%20into%20the%20file%2C%20the%20name%20manager%20still%20remains%20blank%20with%20no%20names%20created.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1403714%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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.

1 Reply
Highlighted

@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