Mervyn,
Something that I have used to document the location of W/S is:
In any cell, enter the formula =Cell("filename")
(Enter it exactly as above , in short, do not enter
the actual filename for "filename")
The above will display and print the drive; full path; and the Tab. Be
cautious though about the Tab, in most versions of XL the Pathe does not
update until a calculation is made.
Thus, if you open a W/B then a W/S and do not hit F9, the Tab displayed may
be incorrect.
HTH Dennis
"Mervyn Thomas" wrote:
The default seems to be to show the filename on the top border in Excel. Is
there any way to include the full path including the drive letter as well?
I have an operator who gets confused as to where she is and this would be
really nice.
|