+ Reply to Thread
Results 1 to 7 of 7

Application.EnableEvents disabled :-(

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    97

    Application.EnableEvents disabled :-(

    i think i've managed to set Application.EnableEvents = false, somehow.. and then saved it... now none of my extensive coding will run :-(



    is there a way to re-enable these... it used to ask at startup, but now it doesn't as i guess i managed to disable them all...

    thanks

    Jonathan
    Last edited by Jollyfrog; 10-06-2010 at 12:15 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Application.EnableEvents disabled :-(

    Do
    Please Login or Register  to view this content.
    from your immediate window and resave the workbook.

  3. #3
    Registered User
    Join Date
    09-23-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    97

    Re: Application.EnableEvents disabled :-(

    i've tried this!

    i added the line to the code that executes when the workbook loads, but no luck... surely if code is not executing then adding code will not be able to help!

    what exactly do you mran by immediate window though?

    thanks

    Jonathan

  4. #4
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Application.EnableEvents disabled :-(

    If events are disabled then the workbook load event won't run.

    In a new workbook create a new macro that is just:

    Please Login or Register  to view this content.

    Run it and then try re-loading your original workbook.

  5. #5
    Registered User
    Join Date
    09-23-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    97

    Re: Application.EnableEvents disabled :-(

    Actually turns out it now just one piece of code thats not working.. thanks for your help!

    Jonathan

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Application.EnableEvents disabled :-(

    Quote Originally Posted by Jollyfrog View Post
    what exactly do you mran by immediate window though?
    see: http://www.cpearson.com/excel/Debug.htm

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Application.EnableEvents disabled :-(

    FYI, if you have code that sets Enableevents to False, you should always have an error handler to make sure it gets set back to true.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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