Tom’s Tutorials For Excel: Hiding Your Named Ranges

Tom’s Tutorials For Excel: Hiding Your Named Ranges
In the below picture, your workbook’s named ranges can be shown by clicking the down arrow next to the Name box.
TTFE0017a
The following macro hides the named ranges, and as the next picture shows, you can work with hidden named ranges the same as you would when they are visible.
Sub HideNamedRanges()
Dim nName As Name
For Each nName In Names
nName.Visible = False
' = True to reverse
Next nName
End Sub
TTFE0017b

Share Button
Posted in Tom's Tutorials for Excel
Tags: ,

Leave a Reply

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

*