Thanks for your help. I am still assessing the codename option as I am
concerned about users changing sheet tabs! One thought is to reset
the tab names from the codenames whenever a link is clicked - not
sure if this is possible?


You could do that in the FollowHyperlink event, but I'm not so sure it's a
good idea. If you don't want them to change the sheet names, you could use
protection or you could hide the sheet tabs. Those would be better options,
I think, than checking for changed sheet names..

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com