Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Getting rid of Prompts in a Macro ?

    Hi,

    In a macro i've created, I delete some sheets and create a new file, populate it with info, then save it.

    But I get prompts whenever it gets to the lines which either delete the worksheets or save the file.

    Is there anyway to suppress these prompts ?

    thx

    C

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Add this right before your troublesome alerts.

    Application.DisplayAlerts = False

    Then be sure to add this before the macro ends.

    Application.DisplayAlerts = True
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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