+ Reply to Thread
Results 1 to 2 of 2

Deleting a sheet error window

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    Chicago, Il
    MS-Off Ver
    Excel 2007
    Posts
    67

    Deleting a sheet error window

    Hello all,
    I wanted to see if there was a way around an error message that i keep getting.
    I have a macro that runs just fine and part of it deletes a worksheet that has data on it and in order to get past it i have to click on the message box to confirm deleting the worksheet is there a code i can use to complete this without having to click

    Please Login or Register  to view this content.
    This is what was recorded in the macro with clicking the button

    Thanks

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Deleting a sheet error window

    Hello Ricardo9211,

    This will suppress the dialog...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1