(Solved) – Hiding defined names and values in Excel using VBA


I’m trying to hide defined names and their values in Excel, I succeeded in hiding the names but the values are still appearing, here is the VBA code.

Sub HideNames()
Dim xName As Name
For Each xName In Application.ActiveWorkbook.Names
    xName.Visible = False
End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *