We also distribute addins off of a server... The problem you are experiencing
is because you are not making local copies of the addins to each local
machine. We have a template that we use to copy the addins to a local
directory on everyones computer instead of everyone sharing the addin from
the server. Until you make local copies for everyone you will run into this
problem... Sorry no easy fix that I know of.

HTH

"Maury Markowitz" wrote:

I have a collection of VBA code we use in a number of spreadsheets that has
been placed in a file cause "autodatabase" and used as an add-in in lots of
things. The file is placed on our fileserver so everyone has access to it.

Practically every time I try to do an update to the code I find, after the
fact, that the file is in "read-only mode". It does not tell me this when I
open it or start editing, only later when I try to save.

It offers no information on why it is in read-only mode. I go around and
quit everyone else out of Excel, but that doesn't seem to help. No one has it
open, so why is it in read-only mode?

In fact, the file in question is password protected, so in fact no one
except me should EVER have it in writable mode.

Can someone offer suggestions on...

1) why this is happening
2) some way to solve it when it happens
3) a better solution so I don't have this problem in the first place

Maury