NEW to VBA - How to renaming user-defined functions using VBA

[super_excel]

hey all,
I am new to this forum and have been using excel since several years. I am now learning VBA and want to migrate 2003 excel files to 2007 and hope that I get answers in this forum.

Specifically, I have inherited some old excel files which had macros that performed financial calculations using function names in the formula. When I save the file to convert to 2007 I get an error message which says that I should rename the user-defined functions.

Can someone please help me as to how to rename user-defined function using VBA code?

Thanks

Deepak

[Bob Phillips]

Can't say I have ever seen that. Can you post one of those 2003 files?