Hi All
I know you can pause a macro using Application.Wait, but I need to have the sheet available for cell AA10's contents to be updated by an external link, and only run the macro if the cell is not updated within 10 seconds.
Would Application.Wait make the sheet unavailable for external update, and if so, if there another way of doing it?
Many thanks in advance for any suggestions.
Trickle
I know you can pause a macro using Application.Wait, but I need to have the sheet available for cell AA10's contents to be updated by an external link, and only run the macro if the cell is not updated within 10 seconds.
Would Application.Wait make the sheet unavailable for external update, and if so, if there another way of doing it?
Many thanks in advance for any suggestions.
Trickle