+ Reply to Thread
Results 1 to 4 of 4

Why isn't EnableEvents Flag set?

  1. #1
    Forum Contributor
    Join Date
    10-02-2008
    Location
    Berkeley, CA
    MS-Off Ver
    Windows 2007
    Posts
    105

    Why isn't EnableEvents Flag set?

    Why doesn't this code work?
    Please Login or Register  to view this content.
    When this code is run the first time, Application.EnableEvents is "False". So why isn't it set to "TRUE" by the first statement?
    If I "display" the events flag after the assignment statement, it shows FALSE.

    When I run this code a second time,the EnableEvents Flag is set to TRUE.

    Thanks,
    Mac

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Why isn't EnableEvents Flag set?

    With just the snippet, it's hard to say. Can you post sample workbook or at least the code in it's entirety?
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    10-02-2008
    Location
    Berkeley, CA
    MS-Off Ver
    Windows 2007
    Posts
    105

    Re: Why isn't EnableEvents Flag set?

    The problem I'm having is that when this subroutine "Reset_Selection_Flag" runs,
    it does NOT reset the EnableEvents Flag to TRUE.
    Sometimes it works if I run it twice in a row.

    Here's it's code:
    Please Login or Register  to view this content.
    And just to be sure, here is the code for "Name_Put":
    Please Login or Register  to view this content.
    Thanks for any help on this.
    Mac

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Why isn't EnableEvents Flag set?

    Hello
    It is working for me and "Flag_EnableEvents" is set to True as I have got your post ..
    What are you seeking for exactly?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ 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. application.enableevents
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2011, 07:09 PM
  2. EnableEvents in a form
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2010, 03:31 PM
  3. EnableEvents
    By wilro85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2009, 07:53 PM
  4. Flag each group in col C if one or more flag in col A
    By oldchippy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-17-2008, 03:42 AM
  5. Application.EnableEvents
    By ilovedurango in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2007, 01:19 PM
  6. Application.EnableEvents help
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-18-2006, 02:00 PM
  7. EnableEvents BeforeClose
    By Stefi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2005, 05:25 AM
  8. application.EnableEvents
    By nc in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 11:05 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