Hidden named ranges

[tiredofit]

I have created a named range called MyNamedRange (scope Sheet1) referring to cell A1 of Sheet1.

Then I hid all named ranges as follows:

    Dim nm As Name
    
    For Each nm In ThisWorkbook.Names
        
        nm.Visible = False
    
    Next nm

To my surprise, I can now create another named range also called MyNamedRange (scope Sheet1) referring to cell E1.

When I unhid all named ranges, there is only ONE named range called MyNamedRange and it refers to cell E1.

Is this a bug?

 

[Ron Coderre]

Seems to be a...um...."feature"
If the range name is visible....attempting to replicate it triggers an error: name already exists.
However, if the range name is hidden....attempting to replicate it simply redefines it.
(Odd behavior, certainly)

 

[tiredofit]

Seems to be a...um...."feature"
If the range name is visible....attempting to replicate it triggers an error: name already exists.
However, if the range name is hidden....attempting to replicate it simply redefines it.
(Odd behavior, certainly)

Exactly, that's my point.

I think it's a design flaw because if you hide all named ranges (not wanting people to change or even know about them), another user might want to create a named range that already exists and thus will change what's there.