+ Reply to Thread
Results 1 to 3 of 3

Vba delete all sheets except active sheet and specified sheets

  1. #1
    Registered User
    Join Date
    11-30-2015
    Location
    FL
    MS-Off Ver
    2016
    Posts
    2

    Vba delete all sheets except active sheet and specified sheets

    I want to delete all sheets in the workbook except the active sheet and specified sheets using there codename

    this works to delete all the sheets but dose not also keep the ActiveSheet
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    11-30-2015
    Location
    FL
    MS-Off Ver
    2016
    Posts
    2

    Re: Vba delete all sheets except active sheet and specified sheets

    I got it to work like this but im not sure if this is the best way to do it


    Please Login or Register  to view this content.
    Last edited by lukerhodes11; 01-16-2017 at 04:45 PM.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Vba delete all sheets except active sheet and specified sheets

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy multiple sheets including active sheet vba
    By alkiviadi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2016, 10:16 AM
  2. Replies: 2
    Last Post: 09-20-2012, 11:54 AM
  3. [SOLVED] Run the macro on all the sheets except active sheet
    By theprincesunil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2012, 02:40 PM
  4. How do I know which sheets are to the RIGHT and LEFT to the Active Sheet?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-04-2011, 11:07 AM
  5. Delete sheets in Active Workbook
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2008, 01:01 AM
  6. [SOLVED] Delete all sheets except the active one...?
    By derobin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2006, 11:10 AM
  7. Replies: 1
    Last Post: 11-04-2005, 10:10 AM

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