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

(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
Next
End Sub

Leave a Reply

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