+ Reply to Thread
Results 1 to 6 of 6

Application.DisplayAlerts = False Doesn't work

  1. #1
    Registered User
    Join Date
    10-20-2014
    Location
    Deventer, The Netherlands
    MS-Off Ver
    2010
    Posts
    2

    Application.DisplayAlerts = False Doesn't work

    Hello all,


    My problem is: Excel does not seem to execute my commands.

    Please Login or Register  to view this content.
    Nevertheless the values of the objects aren't updated. The values ​​are: True and continue to be: True.

    I already made ​​a new Excel file. Containing a macro with only the text above, but problem persists. It seems to be a setting; it has worked and it no longer works. Does anyone have an idea what's going on.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,851

    Re: Application.DisplayAlerts = False Doesn't work

    If you're stepping through the code, ScreenUpdating will remain True. I guess that's so that you can see what is happening on the worksheet.

    Don't know about the DisplayAlerts. What message is it displaying that it shouldn't?


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


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

    Re: Application.DisplayAlerts = False Doesn't work

    Both of those settings reset to True when your code ends and also appear True in step through mode.
    Remember what the dormouse said
    Feed your head

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,851

    Re: Application.DisplayAlerts = False Doesn't work

    @RS: thanks for the confirmation. I knew that ScreenUpdating remained True during Step Through (as it caused me some confusion at one point) but I hadn't realised that DisplayAlerts did the same. Good to know.

    Love the signature. I think I've met some of those psychopaths

  5. #5
    Registered User
    Join Date
    10-20-2014
    Location
    Deventer, The Netherlands
    MS-Off Ver
    2010
    Posts
    2

    Re: Application.DisplayAlerts = False Doesn't work

    Yes, i am stepping (F8) through the code, so that is the reason why. In Word VBA updating does work, so is different in Excel. When I run the macro (F5) in excel everything works well indeed.

    Thank you all for replying.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,851

    Re: Application.DisplayAlerts = False Doesn't work

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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 does not work
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2013, 10:23 AM
  2. Statement: "Application.DisplayAlerts = False" doesn't work for me
    By CEC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2011, 11:11 AM
  3. Application.DisplayAlerts = False showing True
    By SOS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2008, 06:36 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. Application.DisplayAlerts doesn't seem to work
    By jason.draut@fea.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2006, 01:40 PM

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