Results 1 to 3 of 3
  1. #1
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    suppress messages at opening workbooks (NL XL 2003)

    Hello All,

    I'm creating a macro that will open some workbooks and copy the contents of sheets form workbook 1 to workbook 2.
    Both workbooks are almost simulair and make use of the same named ranges.

    Problem 1:
    When opening one of the workbooks I get the message that some links are incorrect. That is okay, so I want to suppress this message, I don't care.
    Is it possible to suppress these messages when opening workbooks?

    Problem 2:
    Then when copying and pasting Excel is showing a message about the use of the named ranges and asks me if I want to use the named range of if I want to create a new name.
    I want to suppress this messgae also, It should use the existing named ranges when pasting. How do I suppress these messages?

    Thanks in advance for your answers.
    Greetings,

    Patrick Schouten
    (The Netherlands)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: suppress messages at opening workbooks (NL XL 2003)

    Does the line

    Application.DisplayAlerts = False

    do what you want? I should be inserted somewhere before the lines that cause the messages.

  3. #3
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: suppress messages at opening workbooks (NL XL 2003)

    Hello Hans,

    You are a livesaver.
    Thanks it works perfect
    Greetings,

    Patrick Schouten
    (The Netherlands)

Posting Permissions

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