Hi
in addition to Leo's answer:
- you may include the cell reference as parameter in your
UDF
- you may add the statement
application.volatile
at the beginning of your UDF

-----Original Message-----
Hi everyone,

I have a workbook which contains several user defined
functions in Excel 2000. I use the workbook in manual
recalculation mode.

The problem is that when I hit F9 it doesn't recalculate
the user defined functions, only the Excel ones. At the
moment I have to go through all the cells with user
defined functions and do F2..Enter. This takes me a long,
long, long time.....

Does anyone know of any setting I can use to force Excel
to recalculate everything???

TIA,
big t

.