thanks for the help fellas,

big t


"big t" wrote:

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