Hoopsah
08-05-2008, 08:01 AM
Hi,
I know this is being a wee bit nasty, but still it is something that I need to do.
I have created a spreadsheet to collate the absence levels within my department.
I made this file open to anyone who knows the password.
What I have now found is that some people go into the program, do their stuff and then walk away leaving it active on their screen. Screensaver will then kick in which is password protected.
I don't want to actively share the workbook as I don't feel that it works properly for what I am doing.
So heres the deal - is there a way I can build in an automatic shutdown of the program/spreadsheet if the user hasn't touched it for a period of time?
I would be nice and try set it for at least half an hour, but it would have to save and exit the program.
Any takers?
Hoopsah
I know this is being a wee bit nasty, but still it is something that I need to do.
I have created a spreadsheet to collate the absence levels within my department.
I made this file open to anyone who knows the password.
What I have now found is that some people go into the program, do their stuff and then walk away leaving it active on their screen. Screensaver will then kick in which is password protected.
I don't want to actively share the workbook as I don't feel that it works properly for what I am doing.
So heres the deal - is there a way I can build in an automatic shutdown of the program/spreadsheet if the user hasn't touched it for a period of time?
I would be nice and try set it for at least half an hour, but it would have to save and exit the program.
Any takers?
Hoopsah