Hello all,
I need to run a macro, although the workbook can be minimazed or another is maximazed infront.
Is there a way to call macro after 10 seconds, and if minimazed executes anyway
Hello all,
I need to run a macro, although the workbook can be minimazed or another is maximazed infront.
Is there a way to call macro after 10 seconds, and if minimazed executes anyway
Sure, Use Application.OnTime for that.
try in standard module such one
Run it and do nothing, just wait and watch. You will see it increases value in cell A1 every 10 seconds.Please Login or Register to view this content.
Now minimize this window and return to it after a minute - you will see A1 increased by 6 by this time.
You can find quick tutorial on this method at Chip's pages: http://www.cpearson.com/excel/OnTime.aspx
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks