Sorry, I guess I misunderstood the issue. I don't have any experience
with the "Share" functionality - I hope someone else can provide better
information.

Dave

mangchik wrote:
Hi Dave. Tx for the reply. Just to inform u, I put my excel file in a
folder and have it shared on the network. Once opened I also pick the
"Tool/Share workbook.." opening it non exclusive. That's when I saw the
message sayinf UDf can't be used. When the other guy opened the file,
the normal security on the level of macro is displayed. that's when the
column's Ive placed the UDF showed an error throughout. Tx again.

Mangchik


--
mangchik
------------------------------------------------------------------------
mangchik's Profile: http://www.excelforum.com/member.php...o&userid=35993
View this thread: http://www.excelforum.com/showthread...hreadid=557806