I'm stumped and would greatly appreciate the input of anyone who can offer it.

I've encountered a very odd bug in a workbook with UDF macros in it. I find
that if I open 2 blank workbooks then another one which has similar macros it
causes the first workbook to change the cell results to #value.

I would greatly appreciate any input on why this could be occuring.

Thanks

Denis