Hello All,
I am a real newbie when it comes to VBA so please excuse me if I don't use the correct terminology
I have this script that is a 15 minute countdown timer:
Sub SetTime()
DownTime = Now + TimeValue("00:15:00")
Application.OnTime DownTime, "ShutDown"
End Sub
Sub ShutDown()
ThisWorkbook.Save
ThisWorkbook.Close
End Sub
The countdown timer will run "Shutdown" (which saves and closes an excel workbook) after 15 minutes of inactivity. I would like to display the current value of "Downtime" in a cell in my spreadsheet so that people know how much time they have left before the excel workbook closes.
I've looked all around but can't find anything....probably because i'm not sure what this would be called.
Thanks so much for any help you can provide,
Ced
Bookmarks