Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Skip confirming message

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dear all,

    I have created a macro. In some part there is a pop up which says do you want to overwrite the not empty cells ? I always confirm with yes but it interupts the macro which is very anoying. Can excel skip the message and automatic overwrite the not empty cells ?

    Thanks in advance.

    Raymond

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Raymond

    Try this at the start of your macro

    Application.AlertBeforeOverwriting = False

    regards
    Derek

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Put this code at the beginning of your macro

    Application.DisplayAlerts = False

    Put this code at the end of your macro

    Application.DisplayAlerts = True

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys, it worked ! You´ve been a great help...

    Raymond

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •