That seems rather unreasonable, there must be better methods
of sharing macros and addins on a network.

There are several MS knowledge base articles see the Related Area in
Read-Only in Excel, Problems with
http://www.mvps.org/dmcritchie/excel...ly.htm#related

Please tell us what your solution turns out to be.


Do you have the ability to create and change a file at that location
if noone else ever touches it . Seems there might be a problem with
the files that the administrator or you antivirus program is allowing you
to update.

If the problem is within Excel caused by file sharing you can turn it
off under Tools.

If the files were copied from a CD-ROM use for a backup or to distribute
later, most applications in Window will create it as read only, XCOPY will not.
Right click on a file or a directory in a file manager or explorer listist and look at properties. If you change read only it will
affect the the file, or if a directory it will affect the directory and all sub directories.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim Thomlinson" wrote in message
...
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