Results 1 to 7 of 7

DisplayAlerts = False chooses the default response

Threaded View

  1. #1
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    DisplayAlerts = False chooses the default response

    Hi,

    While using VBA, when there is a need to suppress alerts, I use Application.DisplayAlerts = False.

    DisplayAlerts = False chooses the default response. What if I had to chose a different response. Is there a way to do it?

    In the attached screenshot, the default is Update, however I wish to select Don't Update everytime this pops up.

    Is there a way to do it?

    P.S. - I know about Application.AskToUpdateLinks = False

    I am just interested in knowing how to select a non default option.
    Attached Images Attached Images
    Last edited by NeedForExcel; 10-14-2016 at 12:33 AM.
    Cheers!
    Deep Dave

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] All in one line of code: ScreenUpdating=False, Calculation=Manua, DisplayAlerts=False
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2016, 03:10 PM
  2. [SOLVED] Application.DisplayAlerts = False does not work
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2013, 10:23 AM
  3. Worksheet Equivalent to DisplayAlerts=False
    By SDruley in forum Excel General
    Replies: 0
    Last Post: 08-18-2010, 09:32 AM
  4. Application.DisplayAlerts = False
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2006, 12:35 PM
  5. Where to put DisplayAlerts = False
    By Joe Fish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2005, 05:05 PM
  6. [SOLVED] DisplayAlerts = false not working
    By Mark Stephens in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2005, 02:05 AM
  7. DisplayAlerts and ScreenUpdate will not set to False
    By Joe at Baso in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-05-2005, 03: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