+ Reply to Thread
Results 1 to 5 of 5

Cannot remove alert box when deleting rows

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    7

    Cannot remove alert box when deleting rows

    Hi all
    I can't get rid of the alert "Delete entire sheet row" using DisplayAlerts = False. Here is my code:

    Please Login or Register  to view this content.
    Any help much appreciated.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,879

    Re: Cannot remove alert box when deleting rows

    Shall work as it is written. but you can try:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-13-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Cannot remove alert box when deleting rows

    I modified (below) with your suggestion and also added a "alerts.false' to the delete column Q line in case that was causing the problem, but still getting the Delete entire sheet row prompt.
    Any ideas anyone?

    Please Login or Register  to view this content.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,879

    Re: Cannot remove alert box when deleting rows

    Either the problem is within other parts of code, or with the sheet itself (merged cells? protection? event handler? sharing? who knows...).
    With simple test sheet I prepared the problem does not occur.
    PS. There is no need to disable alerts again - they remain disabled.

  5. #5
    Registered User
    Join Date
    12-13-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Cannot remove alert box when deleting rows

    Hi Kaper
    Thanks for your help. On that basis I messed around with the code a bit and moved the alerts.false statement to various places and finally fixed the problem with the following code:
    Please Login or Register  to view this content.
    Thanks again!

+ 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. Replies: 0
    Last Post: 10-10-2013, 05:14 AM
  2. Macro for deleting rows which have texts belonging to a "remove list"
    By lanief in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 01:55 PM
  3. alert affect rows by formatcondition
    By nikko50 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2013, 03:09 PM
  4. [SOLVED] Deleting part of a column without deleting whole rows.
    By dstrdOne in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2013, 11:42 AM
  5. Replies: 1
    Last Post: 10-23-2012, 09:12 AM

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