Shared Excel spreadsheet locks when remote technician forgets to close spreadsheet

Hi all,
I work for a company that uses a shared excel spreadsheet located on a shared drive. The spreadsheet works great, technicians can be in there updating the item serial numbers filtering by their name. the main issue I am having is if one of the techs that is in the log forgets to close the file before they go on a coffee break or get pulled away from their station, their computer goes into sleep mode or they close their laptop with the spreadsheet open and it locks the file. When this happens the shared file becomes a regular non shared worksheet and locks everyone out. Is there anyway to stop this from happening, short of telling the tech to close the spreadsheet when they are done editing of walk away from their computers, i have told them mulitple times and we always have offenders.

thanks for your help in advance

Hi Ali,

yes this would be a solution, but i am having trouble trying to get this to work from your link, I already have one module that I run, I can't seem to get the file to work when i follow the links instructions, can you help?

Thanks

how do I post my workbook?