Have you tried marking the file as read-only (in windows via
right-clickpropertiesgeneral tab) ?

Tim

"Maury Markowitz" wrote in message
...
We have an Add-in that normally sits on a fileserver that is added to
everyone's Add-in list.

Excel normally places a lock on a file when it is first opened, and I
have found this is true for XLAs as well. That means that when I need
to make a change to the code in the XLA, I often open it and find it
is in a read-only state because someone else has already opened Excel
before me. The only way to regain access is to kick everyone off the
server and quickly open Excel before they reconnect.

I know it is possible to save an Excel file in a "read-only
recommended" format, and I'm thinking this might help in this case as
well. However, this switch is activated when the file is opened and
invokes a dialog box, which I do not want. Does anyone know if it is
possible to set this mode for an XLA, and if it will have the effect I
am looking for?

Does "Lock project for viewing" may have this behavior as a side-
effect?

Maury