Does any of your UDF code access ranges directly, ranges that are not passed
in as parameters? Anything in the code with ActiveSheet or ActiveWorkbook?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Denis" wrote in message
...
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