+ Reply to Thread
Results 1 to 3 of 3

Worksheet_Change Event won't run more than once

  1. #1
    Registered User
    Join Date
    07-08-2010
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Worksheet_Change Event won't run more than once

    Hi,

    I'm trying to set up some code to run whenever a cell is changed. When I open the workbook and change the cell, the code works, but if I change the cell again, the code doesn't run. If I close the workbook and reopen it, the code again runs perfectly once and then doesn't run if the cell is changed a second time. There are no errors, it seems that the event simply doesn't initiate.

    Here is my code for reference:

    Please Login or Register  to view this content.
    Last edited by David McMillon; 07-08-2010 at 04:02 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Worksheet_Change Event won't run more than once

    You disable events and never reenable them.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-08-2010
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Worksheet_Change Event won't run more than once

    Oh wow, I feel dumb now. Thank you for noticing that. I re-enabled the events and now the problem is solved. Thank you!

+ Reply to Thread

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