View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bura Tino Bura Tino is offline
external usenet poster
 
Posts: 57
Default How to prevent links to ouside sources?

Hi,

This is loosely related to my other posts over the past couple of weeks.
This seems like it would be an FAQ, but apparently it is not.

I have created a VBA add-in (used by several of my colleagues) which
provides a function "giveMeSomeValue()". If my colleague creates a worksheet
which uses this function "=10*giveMeSomeValue()", saves it on a common
drive, and then I open it, the formula becomes

=10*'C:\Path\ReminiscentOf\WhereHeKeeps\MyAddin.xl a'!giveMeSomeValue()

Of course, I have the same add-in installed (in a different place,
typically) so everything would work for me if the original formula remained
intact, and it doesn't in its new form. How do I make it remain in its
original form then?

Many thanks in advance!

Bura