Just when this thread appeared to be dormant ......

Great to see you here Jan Karel, I've incoporated a copy of your Name Manager into a corporate addin that we use for auditing and debugging spreadsheets

While I am still firmly in the "no" camp I do want to pose a name range problem that has been bugging me. I posted this question some time ago at Experts Exchange but had no luck identifying a workaround

"I've built a workbook template with indentical input sheets and I'm using hyperlinks to local range names for major sections (Revenue in A100, Capex in A364 and so on)

Capex ='Alt 2. 10|U|T|M - Mid Mine Plan'!$A$364
etc

All is going well until I rename a sheet, and voila, the hyperlink is now invalid. Has anyone seen this before, and more importantly is there anyway around it? Global range names wth hyperlinks work fine with a sheet name change, Excel just remaps like it normally does

Its an internal work example to be published on our intranet so code is out of the question"

Cheers

Dave