Hi Maury,
Look at Window menu to see if it is creating additional workbooks
which may be list or you may have to also look at hidden workbooks.

Can you tell what file or resource is being held. I don't do anything
on a network.

Look at the parameters in Tools, Options, General
Default File location is the directory where you create new files.
Also also look at File, Properties
Hyperlink base (if it is not empty what does it have)



---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Maury Markowitz" wrote in message
...
"David McRitchie" wrote:
Do you see "[Shared]" on the Title bar, if you do you might take a look at
Highlight, Change Highlighting

Oh I get it. No, this is not the problem. The file in question is an XLA,
which we use all over the place. So the first person to get in in the morning
is granted write access and then me and my fellow developer are locked out.

Is there some way to prevent this? We added a password to the XLA, but that
didn't help the problem. What we'd really like is that anyone who opens it
gets it read-only, but if you type in the password then you get write access.
This seems to be the way the XLS would work, but not the XLA.

I assume this has something to do with the Add-In system, but I can't find
any details on this.

Maury