deleting worksheet without delete dialog box

Discussion in 'Microsoft Excel Worksheet Functions' started by Gary, Oct 20, 2003.

  1. Gary

    Gary Guest

    I am trying to delete a worksheet in a macro, and it will
    always pop up a 'delete' dialog box to confirm....how can
    I remove it, is there special code to do so?
     
    Gary, Oct 20, 2003
    #1
    1. Advertisements

  2. Gary

    Paul B Guest

    Gary, try this

    Application.DisplayAlerts = False
    'Your Code
    Application.DisplayAlerts = True

    --
    Paul B
    Always backup your data before trying something new
    Using Excel 97 & 2000
    Please post any response to the newsgroups so others can benefit from it
    ** remove news from my email address to reply by email **

    "Gary" <> wrote in message
    news:01b301c39739$674cead0$...
    > I am trying to delete a worksheet in a macro, and it will
    > always pop up a 'delete' dialog box to confirm....how can
    > I remove it, is there special code to do so?
     
    Paul B, Oct 20, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    transfer one worksheet to another worksheet without losing format.

    Guest, Aug 18, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    286
    Guest
    Aug 18, 2005
  2. Guest

    deleting values in a worksheet without deleting the formulas

    Guest, Oct 28, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    320
    Peo Sjoblom
    Oct 28, 2005
  3. Guest

    Dialog box with worksheet information

    Guest, Apr 22, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    263
    Bob Phillips
    Apr 23, 2006
  4. Guest

    How to delete the "Insert Function Dialog Box" (dialog box only)?

    Guest, Apr 7, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    530
    Guest
    Apr 7, 2007
  5. Guest

    reference cell from previous worksheet without "naming" worksheet

    Guest, Aug 20, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    339
    Harlan Grove
    Aug 20, 2007
  6. tripy

    how do I delete data in a cell without deleting formula?

    tripy, Apr 20, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    911
    Gord Dibben
    Apr 20, 2008
  7. gems04

    Deleting the text without deleting the formula

    gems04, Jan 30, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    397
    Gord Dibben
    Jan 30, 2009
  8. droth

    How do I save only active worksheet without save all of worksheet

    droth, Feb 21, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    610
    Dave Peterson
    Feb 21, 2009
Loading...