+ Reply to Thread
Results 1 to 5 of 5

Deleting Sheets

Hybrid View

gharding14 Deleting Sheets 08-16-2013, 01:56 PM
TMS Re: Deleting Sheets 08-16-2013, 01:58 PM
gharding14 Re: Deleting Sheets 08-16-2013, 01:59 PM
Mordred Re: Deleting Sheets 08-16-2013, 01:59 PM
TMS Re: Deleting Sheets 08-16-2013, 02:10 PM
  1. 08-16-2013, 01:56 PM #1
    gharding14 is offline
    Registered User
    Join Date
    02-15-2013
    Location
    Halesite, New York
    MS-Off Ver
    Excel 2010
    Posts
    39

    Deleting Sheets

    ActiveWindow.SelectedSheets.Delete

    Is there a way to not get the message box on this command. I want to give no user interaction with this command.

    Please advise.

    Thanks,

    Gary Harding
    Reply With QuoteRegister To Reply
  2. 08-16-2013, 01:58 PM #2
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,313

    Re: Deleting Sheets 

    Application.DisplayAlerts=False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts=True

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 08-16-2013, 01:59 PM #3
    gharding14 is offline
    Registered User
    Join Date
    02-15-2013
    Location
    Halesite, New York
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Deleting Sheets

    Cheers. Forgot about that.

    Thanks TMShucks! Good luck in the Premier league this season (I am an Everton supporter).
    Reply With QuoteRegister To Reply
  4. 08-16-2013, 01:59 PM #4
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Deleting Sheets 

    Application.DisplayAlerts = False
 ActiveWindow.SelectedSheets.Delete
 Application.DisplayAlerts = True
    LoL, I'm too slow today!
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---
    Reply With QuoteRegister To Reply
  5. 08-16-2013, 02:10 PM #5
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,313

    Re: Deleting Sheets

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro for deleting last row in all sheets except 3 sheets
    By harishb63 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2013, 05:10 AM
  2. Need help deleting sheets and moving existing sheets down in order
    By MAGICofSeth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2012, 06:13 PM
  3. Deleting sheets
    By christo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2008, 11:17 PM
  4. Help on deleting sheets?
    By doug53098 in forum Excel General
    Replies: 1
    Last Post: 07-08-2005, 12:05 AM
  5. deleting sheets 2&3
    By doug53098 in forum Excel General
    Replies: 2
    Last Post: 07-07-2005, 03:22 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1