The first one you will need a macro, a line of code something like this

activesheet.name =[a1]

for the second one this formula should work, the file must be saved first

=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

"nospam" wrote in message
...
Hi,

RE Excel 2002 (version 10) sp3

is it possible to have a cell value displayed on the sheet tab or have
the sheet tab displayed in a cell?

Thanks