Why don't you simply enter the first 10 characters then? It'll be as meaningful to anyone as a truncated longer sheet name and if that's all you need ..... you can always put the full name of the sheet in a cell elsewhere on the sheet for other users.
IIRC (it was in my previous job), when the project expenditure sheets came round, along the top were a bunch of buttons created using macros (VB?). Selecting one would perform a specific calculation on the input figures and take you to the result but I'm sure that the result was on a different sheet to the input.
... this spreadsheet has information in the tab that is not avaiable anywhere else in the Worksheet and that information is used by various buttons, formulae and hyperlinks ... both on each individual worksheet and in a master / index worksheet.
It's not a *problem*, as such, it would just make navigation a bit easier sometimes ... doesn't look like it's possible though, from replies so far, never mind !!!