If you share this addin with lots of people connected to a common share, you
could put the addin in a folder on that sharename.

If all the users map to that drive using the same letter, it would be easier.
If they don't map to it or map as a different drive letter, then I'd try
installing the addin by browsing to that UNC path.

If the users don't have a common drive to use, you could tell them that your
addin goes in a folder called:

C:\PetersUtils

And then tell them to browse to that folder when installing that addin
(tools|addins).

By using a common drive (C:) and a common folder, it should work ok. (You'll
have to follow the same rules, too.)



Peter Owitz wrote:

I wrote a small function to manage some error handling I normally do with
excel functions.

I saved this as an add-in.

When I opened a shared file on another machine, the function pointed to my
C: Drive, instead of giving a ?Name? error.

Can someone point me to a method of avoiding this? I want the function to
work like an add-in, not a function sitting on my desktop.

--

Dave Peterson