calling VBA function within a worksheet
 

When calling a function created in a different workbook, I get the #NAME! not
defined even thought I put down the spreadsheet name.
"=anotherbook!myfunction(A1)"
Am I doing something wrong?

Thanks

calling VBA function within a worksheet
 

Is the other workbook open ?

Regards

Trevor


"matelot" wrote in message
...
When calling a function created in a different workbook, I get the #NAME!
not
defined even thought I put down the spreadsheet name.
"=anotherbook!myfunction(A1)"
Am I doing something wrong?

Thanks

calling VBA function within a worksheet
 

Yes.

"Trevor Shuttleworth" wrote:

Is the other workbook open ?

Regards

Trevor


"matelot" wrote in message
...
When calling a function created in a different workbook, I get the #NAME!
not
defined even thought I put down the spreadsheet name.
"=anotherbook!myfunction(A1)"
Am I doing something wrong?

Thanks