I'm using the following macro which allows me to copy some values under certain conditions on Sheet1.
Since I'm also using Application.OnTime my macro runs on every 30 seconds.
However, when I open some other Sheet on the same Workbook (that "other" Sheet becomes active) macro simply stops counting and nothing happens in Sheet1...
I would like my macro to run (in this case data are on Sheet1) no matter which Sheet or Workbook I open (is active).
Any idea how to solve this?
Here is the code: