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

Is the other workbook open ?

Regards

Trevor


"matelot" <[email protected]> wrote in message
news:[email protected]...
> 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

Yes.

"Trevor Shuttleworth" wrote:

> Is the other workbook open ?
>
> Regards
>
> Trevor
>
>
> "matelot" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>