VBA Only Unhide Workbook Scope Named Ranges

Asked Jan 13 '21 at 03:23

Active Jan 13 '21 at 04:26

Viewed 24 times

I have a workbook with many named ranges (both sheet and workbook scope) which are all hidden. I have a macro that can unhide all of the name ranges but I only want to unhide the workbook scope named ranges, NOT all the sheet scope ranges. Can someone please help me with my code below?

Thanks.

Sub Unhide_All_Ranges()

Dim xName As Name

For Each xName In ActiveWorkbook.Name
    xName.Visible = True
Next

End Sub

edited Jan 13 '21 at 04:26

braX

11,506
5
20
33

asked Jan 13 '21 at 03:23

Patrick

1

Start [here](https://stackoverflow.com/questions/8656793/programmatically-determine-if-a-named-range-is-scoped-to-a-workbook)? – BigBen Jan 13 '21 at 03:24
This is exactly what I was looking for. Thanks @BigBen – Patrick Jan 13 '21 at 03:33

VBA Only Unhide Workbook Scope Named Ranges

0 Answers0