none
Excel 2007 VBA EnableEvents = false not working RRS feed

  • Question

  • I'm using the Worksheet_Change(ByVal Target As Range) event to do certain changes on this worksheet. To avoid the circulation, because these changes would trigger the event over and over again, I set Application.EnableEvents = False. In Excel 2003 this is working, in 2007 unfortunately not.

    Does anyone have a clue?

    Cheers wgk
    Thursday, July 23, 2009 11:30 AM

All replies