autoclose

Hi all, I have what seemed like simple vba code from Microsoft's website, but I am running into errors. I have a workbook where a userform opens when the workbook is started and a message prompts that a macro will run in 90 seconds unless the command button is clicked. Clicking the button...

Hello all, I am having an issue where this workbook will reopen after closing. I've googled many different solutions, and still can't get it to stop. The idea behind this is that if the workbook is inactive, then a userform will pop up informing them that they have 90 seconds to confirm they...

Hi all, I have a workbook that we use in work in work with a timer function that shuts down the workbook when the workbook hasn't been used for 15 minutes. However, if my peers select a cell and go into edit mode then no macros run and then they go home so no one can edit it. Is there a...

Hi i have issues with my new macro enabled excel file, sometimes the excel file auto close by itself without error message or anything and it happens so rarely but i loose lot of data due to this issue .. any solution for this issue

Hi all, I'm a bit perplexed as to why this code isn't working for me; especially considering how I've managed to get it working in other ways. Basically; I want my workbook to auto-save and close after a period of inactivity (set at 30 seconds), which is defined in a module; using this code...

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"...