Event Triggers are not working

  • I have a worksheet that has a Private sub that should be triggered by a worksheet_change event.

    If I enter the "

    Application.EnableEvents = True

    " in the Immediate window, my trigger works, but once I close my spreadsheet and reopen it, the event trigger no longer works. I also added the "Application.EnableEvents = True" statement to the workbook_open sub, hoping that would resolve my problem, but it does not.

    How do I ensure that my event handler will always be enabled for a spreadsheet.

  • Re: Event Triggers are not working

    I reviewed the Macro security and the box for "Trust access to visual basic properties was not checked,

    I checked it, saved my spreadsheet and it seems to be working now.

    Thank you for your quick response. I never thought to look there.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!