+ Reply to Thread
Results 1 to 3 of 3

Execute macro even if WB is minimazed

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Execute macro even if WB is minimazed

    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

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Execute macro even if WB is minimazed

    Sure, Use Application.OnTime for that.

    try in standard module such one
    Please Login or Register  to view this content.
    Run it and do nothing, just wait and watch. You will see it increases value in cell A1 every 10 seconds.
    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

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Execute macro even if WB is minimazed

    Quote Originally Posted by Kaper View Post
    Sure, Use Application.OnTime for that.

    try in standard module such one
    Please Login or Register  to view this content.
    Run it and do nothing, just wait and watch. You will see it increases value in cell A1 every 10 seconds.
    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
    Thanks for your help , it worked with my older programming, although can't have this, i changed my entire program. Cuz once a macro timeout is executed in EXCEL1, the timer stops in EXCEL2.

    I will let it this way

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Execute a macro in a closed workbook, or open and execute without the user noticing
    By cearaujo123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2015, 06:44 PM
  2. code to execute a keyboard shortcut or to execute a toolbar button
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2015, 12:16 PM
  3. Execute one macro from within another ?
    By Originalgoth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2010, 03:57 PM
  4. Macro to populate a cell and then execute another macro
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2008, 02:19 PM
  5. the macro don't execute
    By robson soares in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-12-2006, 03:00 PM
  6. execute a macro
    By Rossy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2005, 05:10 AM
  7. [SOLVED] Execute Macro
    By Yves in forum Excel General
    Replies: 3
    Last Post: 04-23-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1