I have a Sub that basically changes a few cell values every 2 minutes exactly and at the very end of the macro running I want it to select cell M5. The code I use to select M5 is
However, when I'm using another workbook and when this automatic code runs every 2 minutes then I am taken from the workbook where I'm at onto the workbook where the code runs from. It does select cell M5 just fine but I don't want it to take me to the workbook when it happens. I want to be left on the workbook I was on.
Any ideas how to achieve this?
Thanks.
Bookmarks