macro not found, but it is there

J

Jim Conrady

Forgive me for the improper use of the enter key on the post I just made on
this subject.

I have the need to compute the minutes between 2 numbers. I wrote a macro
(minsBetween) and put it in the Personal.xls workbook. In the spreadsheet, I
have the code...

=(PERSONAL.XLS!minsBetween(B5,C5)+PERSONAL.XLS!minsBetween(D5,E5))/60+F5

This worked find for a while, but now when I open the spreadsheet every
value gets the #NAME? error. I opened the macro editor, and minsBetween is
in Personal.xls. However, when I do alt-F8, it is not listed as a macro...
I checked, and I can only find one Personal.xls on any accessible drive. I
also tried moving the macro out of personal.xls and into the workbook: still
did not work.

Help!

Jim
 
Top