I created a UDF that returns the filename of the active file:
however, when I named the file I forgot that the CELL function has an option for "filename". Is there a way to remove an older UDF such that my CELL function will work. I have already tried renaming the UDF to FName, but now XL doesn't recognize FName as a function, and it still recognizes FileName as a function.
I have these UDF's stored in my personal.xls file if that matters and I am running XL2000 on Win2000
I can't seem to figure out why it wont reconize the new UDF name?
EDIT: Here is my new function code if that matters:
however, when I named the file I forgot that the CELL function has an option for "filename". Is there a way to remove an older UDF such that my CELL function will work. I have already tried renaming the UDF to FName, but now XL doesn't recognize FName as a function, and it still recognizes FileName as a function.
I have these UDF's stored in my personal.xls file if that matters and I am running XL2000 on Win2000
I can't seem to figure out why it wont reconize the new UDF name?
EDIT: Here is my new function code if that matters:
Code:
Public Function FName() As String
'i.e. [file.xls]
Application.Volatile
FName = ActiveWorkbook.Name
End Function