Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    113

    Unanswered: How can I turn of warnings

    I need to turn of warning messages when i delete a sheet by code. Somebody knows how?

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    Put this before the code that deletes the sheet.
    Code:
    Application.DisplayAlerts = False
    And this after.
    Code:
    Application.DisplayAlerts = True

  3. #3
    Join Date
    Nov 2005
    Posts
    113

    Thank you a lot!

    Thanks again - you are an angel.

Posting Permissions

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