Mohan
Check out Bob Phillips' site for this.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben Excel MVP
On Thu, 22 Dec 2005 15:52:02 -0800, "Mohan De Silva"
wrote:
I need to insert the file name in a cell of the work page (with a funtion)
and be able to change automatically if & when the file name id edited. I Use
this on a cover page .