Hi Fabio,

No, you cannot update it if it is open, but that is why I suggested an
overnight update, when they would all be out.

They do not need to exit Excel though, they just need to uncheck the add-in
(ToolsAddins) whilst you update, then re-check it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi Bob

It worked, but when I need to update any function in the ".xla" everyone
who
had "add in" the ".xla" needs to close Excel. Then I can update.

Is there another way to update the my library without every one goes out
of
Excel, or another way to make a library or functions to be used in Excel ?

thx

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory, updating
it
overnight will mean they all get the updated version when they start
Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to
share
them
with my development group. I had already saved it as ".xla" on a
common
path
that all can access, but when I program new function every body have
to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the
newest
version of the functions from the net ?

thx