DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
I use a lot of shared spreadsheets for tracking activity of my field colleagues.
The user will open the spreadsheet, assuming no one else is not already in the spreadsheet, and enter their information.
Then when they are done, they (are supposed to) save and get out of the spreadsheet.
On a regular basis, the user will forget the get out of the spreadsheet, and no one can get in until they do.
Is there a way to have a forced close of the document after a certain period of time with no activity(ex: 15-20 minutes)?
I am thinking something like a macro, but it would be above my skill set.
The user will open the spreadsheet, assuming no one else is not already in the spreadsheet, and enter their information.
Then when they are done, they (are supposed to) save and get out of the spreadsheet.
On a regular basis, the user will forget the get out of the spreadsheet, and no one can get in until they do.
Is there a way to have a forced close of the document after a certain period of time with no activity(ex: 15-20 minutes)?
I am thinking something like a macro, but it would be above my skill set.