Legacy Function Macros in Excel 2007

Many years ago (pre-Excel 4.0) I created a spreadsheet that uses a few custom function macros to perform pipe flow analysis calculations. Over the years, as I have upgraded to newer versions of Excel and the spreadsheet opens and runs without any errors. I do get an error message when I try to save (warning about Excel 4.0 macros). I'm trying to figure out how to use these functions in another spreadsheet, but I am struggling.

The only visible reference to any of the functions is either through the User Defined section of the Insert Function menu or as a "Refers To" entry in the Name Manager. Here's how one of them looks in the spreadsheet cell.

=Manning_macro!Capacity($C$7,$C$5,$D$5)*1.55

I cannot find any reference to "Manning_macro" in the worksheet, at all.

1. How do I access and edit these functions?

2. How do I use them in other spreadsheets?

Thanks for looking.
Rick

Originally Posted by Paul

If you right-click on any of the worksheet tabs, can you select 'Unhide' and then see an entry called "Manning_macro"? The macro functions may have been added to a Macro "worksheet" which you cannot see in the VB Editor sheet listing.

Thanks a million. Sometimes the obvious answer must be applied with humility. I kept right-clicking the lower area -- but not directly on the visible sheet name. Once done, all the macros were visible. When I uncovered the macro, I notices I had last edited it in 1991! Time files!

Now to experiment with modernizing this tool.