+ Reply to Thread
Results 1 to 4 of 4

Using Application.DisplayAlerts within Several Macros

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Using Application.DisplayAlerts within Several Macros

    Greetings,
    I have several macros that are being used within other macros. Each of the Macros begin with the following code. Should the use of this code be limited to the Macro running/calling the other Macros?
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    365
    Posts
    397

    Re: Using Application.DisplayAlerts within Several Macros

    If you don't need the screen updating or alerts to show between each sub being run, then I personally would put those lines in the "calling" sub rather than each called sub.

    Beth.

  3. #3
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    417

    Re: Using Application.DisplayAlerts within Several Macros

    I normally check the current status at the beginning of a sub, and then reset it to that at the end. e.g.
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Using Application.DisplayAlerts within Several Macros

    Thank you both for the advice!

+ 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. [SOLVED] Application.DisplayAlerts = False not setting
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-31-2018, 10:00 AM
  2. [SOLVED] Application.displayalerts not changing
    By ggs22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2015, 08:12 AM
  3. Application.Displayalerts not working...
    By rbon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2015, 11:48 PM
  4. [SOLVED] Application.DisplayAlerts !
    By ks1102 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2013, 04:51 AM
  5. Application.DisplayAlerts not working
    By yogesh thakker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2010, 05:07 AM
  6. Application.DisplayAlerts = False
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2006, 12:35 PM
  7. [SOLVED] Application.DisplayAlerts
    By TK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2005, 04:06 PM

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