Results 1 to 3 of 3

When will macro in module run when Application.EnableEvents is set to False?

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    40

    When will macro in module run when Application.EnableEvents is set to False?

    Hi,

    I have a worksheet with a number of macros in it that run when a value in the worksheet changes. For each of these macros, I have set

    
    Application.EnableEvents=False
    and the last line of the macro is

    
    Application.EnableEvents=True
    My questions is if another macro within a module is called while the worksheet change macro is running, will it immediately run after the worksheet change macro or will it be completely ignored and will have to be called again at such time when on of the worksheet change macros are not running?

    Many thanks in advance for your help,

    twills
    Last edited by twills; 10-20-2010 at 06:14 AM. Reason: Bad title

Thread Information

Users Browsing this Thread

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

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