I've a udf and it works fine.when I send the files to others it shows up as #value.they have to click on the enable macro to get it work.is there any way to fix it without enabling macro.