Hi!

I'm kind of new to VBA and to forums so I hope I express this correctly...

I have a workbook data file located at a network sharepoint in order to be used by multiple users. We want to avoid the issue of someone leaving the file opened avoiding other users to work on it. We do not want the user to be forced to create a copy of the file because other files are linked to it. So I want a code that could Auto Save and Close the workbook after 15 minutes of inactivity with the following requirements (if possible):

1. After 15 minutes of inactivity provide a pop up message warning the user that the file is going to be closed due to inactivity. I want the message to have two choices: OK and Cancel. If Cancel is selected then the workbook stills open and re-starts the 15 minutes counter. If the user selects OK the file must save and close.

2. If after 10 seconds no action is taken with the pop up message then the file should save and close.

3. If the Workbook is not the active file, the pop up message should activate the workbook in order for the user to be aware of the inactivity and possible closing of the file.

Hope I provided the information needed.

Thanks in advance!