I stumbled through a solution>https://answers.microsoft.com/en-us/...cec8eda55?db=5
The macro actually works but the downside is that the loop monitors worksheet change in a continuous cycle that disables every other modules from working.
My question is like asking: is it possible for two macros to run concurrently? If no, what better macro can I use?
I'm relatively new to VBA, a breakdown will be appreciated.
Thanks.
To answer your question; no, you cannot have two macros run concurrently.
The solution below uses an On Time macro that runs after a specific time has passed. The code extends that specific time for various workbook events. If there are no workbook events (user is idle) then it runs your macro when the last set time is reached.
Put this code in a standard code module e.g.; Module1. Set your Idle time and your macro name to suit.
Please Login or Register to view this content.
Put this in the ThisWorkbook code module
Please Login or Register to view this content.
Last edited by AlphaFrog; 06-27-2018 at 02:35 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@alphafrog Thanks!
It works! But it seems like inserting or editing a chart does not reset the timer
You're welcome.Originally Posted by chrismeeky
Yes, this method is imperfect. Inserting\editing a chart is not a triggered event. I don't know how to get around that using this method. You'll likely discover a few other activities that are not recognized as well.
@AlphaFrog. Since the user is not required to edit designs/insert charts, the macro is perfect. Thanks for helping!
Chris.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks