I have a protected worksheet and if one of our users has it open, sometimes it will allow another user to open it and edit it. Other times it works as it's supposed to and lets the second user know it is in use and can't be edited. What could cause this to happen and how do I fix it?


thx
kab1