Hi there
Does anyone know if there is a way (VBA or otherwise) to automatically save and exit a file in excel after a period of inactivity?
The reason I ask is we have pc's that automatically go into hibernation (with password protection) and normally this coincides with that person being in an excel spreadsheet and therefore preventing access for anyone else.
Just wondered if there is a way to (after say 10 mins of inactivity) to save and close the file automatically?
Any help would be great.
regards
Does anyone know if there is a way (VBA or otherwise) to automatically save and exit a file in excel after a period of inactivity?
The reason I ask is we have pc's that automatically go into hibernation (with password protection) and normally this coincides with that person being in an excel spreadsheet and therefore preventing access for anyone else.
Just wondered if there is a way to (after say 10 mins of inactivity) to save and close the file automatically?
Any help would be great.
regards