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 still remains blank with no names created.

excel

1 Reply

  • 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