+ Reply to Thread
Results 1 to 2 of 2

Application.EnableEvents and Application.ScreenUpdating doubt

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    62

    Question Application.EnableEvents and Application.ScreenUpdating doubt

    Hi,

    Could you please give me some advice on how to properly use Application.EnableEvents and Application.ScreenUpdating?
    The below dummy macro runs with no problems, but if a error is found I think it's not enabling EnableEvents and ScreenUpdating back, is it?
    It will go to Exit sub and therefore ignore the previous code. Is it OK to have the TRUE lines between Exit Sub and End Sub?

    Please Login or Register  to view this content.
    Thank you for your time!

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Application.EnableEvents and Application.ScreenUpdating doubt

    If you Exit the sub then the events are left turned off... Generally, you should explicitly turn them back on again however you exit the procedure.

+ 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. Scope of Application.(EnableEvents | ScreenUpdating | DisplayAlerts)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2017, 07:22 PM
  2. [SOLVED] VBA Application.EnableEvents and Application.ScreenUpdating
    By mcmunoz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2013, 10:24 PM
  3. Application.ScreenUpdating not working with Application.Run
    By WaqasTariq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 02:24 PM
  4. application.enableevents
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2011, 07:09 PM
  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. application.EnableEvents
    By nc in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 11:05 AM

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