Excel Use CodeName with Name Manager without VBA

[MOStans]

I would like to use the CodeName with the Name Manager without using VBA. I have a spreadsheet with four years of data in it and when 2016 is done I want to change the tab name to 2020 without having to change range name references.

Is there a way to put the code name in when using the Formulas>>Name Manager on the Excel Ribbon?

I tried putting the Code name in but the Named Range does not show in the drop down even though the scope is workbook.

Is it possible to do this?



Thanks!

 

[Norie]

You can't use the codename in a formula so you can't use it in Name Manager.