idle

Good Afternoon, I want to create an Excel Spreadsheet which automatically closes after a certain time of being idle as multiple users need access to it. I have found coding for that but unfortunately for it to work Macros need to be enabled. I have found what I need which works separately but...

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

I am trying to get the average idle time in-between two-time stamps. when I do so I get a number I don't believe is accurate. depending on the format it shows weird times one being 3 hours and another being 13:3:3:53 when formatted with days but I know it doesn't mean 13 is days. When the...

Good morning All, Would anyone be able to assist with a vba code that will automatically close a workbook and save changes once it has been idle for a certain amount of time, say 30 seconds? Thank you Herbie C

I have a workbook with 20 sheets. Is there a code to revert or go to a certain shot after idle for 15 min?

Hi all! Very happy to find this resource I will try to be as thorough/concise as I can be - I have a CSV file that we download for a number of customers. I have created a macro to remove all of the unnecessary information from that CSV file - Now, there is a field of audit notes that I am...

Hi, I need help figuring out the best way to use the data in sheet 2 to populate all the fields in sheet1. Ultimately, sheet1 will be converted to PDF when all the information is gathered. I'm struggling with making it look good. I'm Currently using If Statements for the yes no questions...

Hi All, I'm wondering if someone can help, I have a shared workbook that I've added the below code to so that it automatically saves and closes if someone has it open for 30 minutes and hasn't used it (it was constantly annoying people leaving it open all the time!!) :banghead: It works...

Currently I have a dashboard style excel document used by multiple users on a network, these users require read/write priviledges and as such only one read/write access file can be opened at a time because of the network.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...