Rustynailed, put this in the cell you want the worksheet tab name in, file
must have been saved

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Rustynailed" wrote in message
...
I have a workbook that contains stats for my team, each team member as ther
own work sheet, I name each sheet with there name, What i want to happen
is
when i label the Worksheet Tab with the name of the employee name its
Populates in any cell i chose in the work sheet,

Thanks

Rusty