Forum Discussion

vasudevparakkal's avatar
vasudevparakkal
Copper Contributor
May 19, 2020

Excel Name Manager

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 stil...
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 19, 2020

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