Names of named ranges not displaying in Name Box

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,532
Office Version
  1. 365
Platform
  1. Windows
For some reason, none of the names of my named ranges are showing up in the Name Box. I'm pretty sure they were yesterday. This is true for every sheet in one workbook. In sheets in other workbooks, they do show up.

Is there some setting that suppresses the names being displayed?

This is a workbook I downloaded from this Bureau of Labor Statistics page:

May 2021 National Occupational Employment and Wage Estimates

I downloaded it again. The newly downloaded version does not have this problem, so I am assuming it's something I did, but I have no idea what.

I found another thread here with a similar topic, but those were all dynamic ranges. These are not. Most of them are a single cell. One or two are multiple cells.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
I am not aware of a "setting" that suppresses names. You can hide names but you need to run code to do that.
I would be curious as to what happens if you run an unhide macro.

VBA Code:
Sub UnHideNames()
Dim nm As Name
For Each nm In Application.ActiveWorkbook.Names
    nm.Visible = True
Next
End Sub
 
Upvote 0
I am not aware of a "setting" that suppresses names. You can hide names but you need to run code to do that.
I would be curious as to what happens if you run an unhide macro.

VBA Code:
Sub UnHideNames()
Dim nm As Name
For Each nm In Application.ActiveWorkbook.Names
    nm.Visible = True
Next
End Sub
I never got to run your macro. After I posted the question, I closed that workbook and went to bed. This morning when I reopened it, the names were displayed. ???
 
Upvote 0

Forum statistics

Threads
1,214,965
Messages
6,122,500
Members
449,090
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top