dkaydkay
04-02-2014, 05:14 PM
Did a search and can't find a solution. I have a workbook that processes cells and then opens a userform with a countdown timer to allow the user to cancel before the data uploads to a server. Everything runs fine if the macro is called and the user stays in excel the whole time.
But if the user starts the macro, then goes to another application before all the cells are done processing, the userform doesn't open and the timer doesn't start.. until the user clicks back on Excel. Is there a way to force the userform to open even though Excel isn't the active application?
Thanks in advance!
But if the user starts the macro, then goes to another application before all the cells are done processing, the userform doesn't open and the timer doesn't start.. until the user clicks back on Excel. Is there a way to force the userform to open even though Excel isn't the active application?
Thanks in advance!