+ Reply to Thread
Results 1 to 5 of 5

Automaticly delete extra sheet

  1. 04-06-2011, 04:42 PM #1
    timmtamm
    timmtamm is offline
    Registered User
    Join Date
    02-11-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    98

    Automaticly delete extra sheet

    Shouldn't be to hard, I would think. I just don't have the know-how.
    I'm looking for how to get the code to automatically delete a sheet I don't need anymore. No popup asking for confirmation.

    Currently the following code creates a popup declaring "there might be information on the other sheet, are you sure you want to delete?"

    Please Login or Register  to view this content.
    Full code is here

    Please Login or Register  to view this content.
    Last edited by timmtamm; 04-06-2011 at 05:07 PM.
    Excel: Not my profession, but useful in it.
    Reply With QuoteRegister To Reply
  2. 04-06-2011, 04:48 PM #2
    TMS
    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
    44,502

    Re: Automaticly delete extra sheet 

    Please Login or Register  to view this content.

    Regards
    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. 04-06-2011, 04:49 PM #3
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Automaticly delete extra sheet

    Try...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  4. 04-06-2011, 05:08 PM #4
    timmtamm
    timmtamm is offline
    Registered User
    Join Date
    02-11-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    98

    Re: Automaticly delete extra sheet

    Thanks! That works perfectly.
    Reply With QuoteRegister To Reply
  5. 04-06-2011, 05:09 PM #5
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Automaticly delete extra sheet

    Glad it worked for you
    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)

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