Nigel wants a hyperlink to another sheet based on the sheet’s Codename, rather than what’s displayed on the tab. The tab can be changed by the user is the issue here, I guess. As part of that, this is a function I came up with to do the conversion. I didn’t really look around for one, so if there’s a better one out there, let me know.
On Error Resume Next
CodeToFriendly = wb.VBProject.VBComponents(sCode).Properties(“Name”)
It’s too short. I know I’m missing something. The error checking, by the way, is in case an invalid sCode is supplied.