So i've come across a number of spreadsheets over the years where named ranges have been hidden.

I've never managed to figure out how this comes to be but from what i can deduce possibly from very old legacy files - does anyone know?

Also is it possible to hide/unhide named ranges without using VBA?

FYI, luckily come across below useful code from this forum which i run on all files to unhide old named ranges 

Sub ShowAllNames()
Dim n As Name
For Each n In ActiveWorkbook.Names
n.Visible = True
Next n
End Sub