Thanks to this forum, I have learned to use the MID(..Cell(..))
functions to display the worksheet part of a filename in a cell, which I
use for automatically dating my weekly timecard, using the tab name as
the only reference I need to change. It then automatically dates the
days for me.

However, when I send a copy of the sheet to my dept. secretary, once on
her computer, the filename's path is completely different, and the
reference comes up as gibberish.

Any idea as to how to extract just the sheet name, without using the
whole filename? Or can I easily lock the cell's value, so that it
doesn't change even when the location changes?

Davey.