Closed Thread
Results 1 to 3 of 3

Pausing everything until another Macro is run

  1. #1
    Registered User
    Join Date
    12-26-2016
    Location
    London, England
    MS-Off Ver
    365
    Posts
    79

    Pausing everything until another Macro is run

    Hi - I have some code that copies across an image and I need to pause everything until the user selects the image which then removes it from the sheet. I don't want the user to be able to do anything on the sheet until the Image has been removed.

    I need to first macro to Pause until the user clicks the image (which has the 2nd macro assigned to it) - So need the code that goes at the end of Show_Help_Image

    Can anyone help??

    Many thanks in advance...

    Here is my code....

    Please Login or Register  to view this content.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Pausing everything until another Macro is run

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/showthread.php?t=1168758
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Pausing everything until another Macro is run

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/showthread.php?t=1168758

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pausing A Macro (allow user to extract data) aAnd Resume Macro
    By jbumps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2013, 01:59 PM
  2. Pausing a Macro During Execution
    By Zeos6 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2013, 06:58 PM
  3. Pausing a Running Macro
    By AccountantCost in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2009, 07:56 AM
  4. Pausing before macro
    By dylanemcgregor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2009, 05:40 PM
  5. Pausing a MACRO
    By accur8ly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2007, 01:06 AM
  6. Pausing Macro
    By Dohko in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-05-2007, 05:25 PM
  7. Pausing a Macro
    By PaulW in forum Excel General
    Replies: 0
    Last Post: 05-30-2006, 09:10 AM

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