Here's the problem:
I am running Excel 2000
I created an addin file to avoid the "... contains macros" pop up. The
addin contains a custom function.
This is where it gets tricky - I share this workbook by placing it on a
drive on the company's intranet.
The formula changes from calling the function from the addin when it is
saved to the C: drive to a complicated link with the address from my C:
drive with the drive letter changed to the intranet drive letter.
From: =Alarm.xla!AVGAlarm(AA6:AA36,"225860",AA37)
To: ='R:\Documents and Settings\kowalsd\Application
Data\Microsoft\AddIns\Alarm.xla'!AVGAlarm(AA6:AA36 ,"225860",AA37)


--
dbjk
------------------------------------------------------------------------
dbjk's Profile: http://www.excelforum.com/member.php...o&userid=26078
View this thread: http://www.excelforum.com/showthread...hreadid=394119