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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
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:
    199
    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:
    210
    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:
    155
    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:
    338
    Guest
    Apr 7, 2007
  5. gems04

    Deleting the text without deleting the formula

    gems04, Jan 30, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    250
    Gord Dibben
    Jan 30, 2009
Loading...

Share This Page