Shoutbox

Thx for the replies.

The file is on a shared network drive. So if anyone opens it others will only get the file to open as read only.
I already have put in a macro that saves and closes the file when no modification has been done for a period of 30 min.
But I have to do a quick update once in while so I was thinkin maybe to link the excel file with a button on another workbook that when pressed it just closes the file.

Remote desktop is kind of difficult to do here and sharing a workbook through excel limits the options of editing.

So for the button idea maybe: can a macro check another file on the network so when something changes the save/close macro in the original workbook gets enabled?