+ Reply to Thread
Results 1 to 5 of 5

delete worksheets based on color

  1. 07-13-2017, 01:38 PM #1
    xi603
    xi603 is offline
    Forum Contributor
    Join Date
    03-31-2017
    Location
    usa
    MS-Off Ver
    2013
    Posts
    104

    delete worksheets based on color

    hi, I just need some code to delete all the worksheets in my workbook that have a tab color of red. the macro recorder doesn't work well since my sheet names can change. thx.
    Reply With QuoteRegister To Reply
  2. 07-13-2017, 01:47 PM #2
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: delete worksheets based on color

    Hi xi603
    This should assist...
    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 07-13-2017, 01:47 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: delete worksheets based on color 

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  4. 07-13-2017, 02:11 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: delete worksheets based on color

    FWIW:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 07-13-2017, 02:14 PM #5
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: delete worksheets based on color

    Glad we could help...Thanks for rep+
    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] Delete Row Based on Color
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-04-2014, 01:50 PM
  2. delete a row based on color of cell
    By karimretina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2014, 05:18 AM
  3. [SOLVED] Delete row based on red color font
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2014, 10:02 AM
  4. Delete Columns Based On Fill Color
    By jlkirk in forum Excel General
    Replies: 7
    Last Post: 01-28-2013, 02:00 PM
  5. Compare 2 worksheets, delete dupes and group by back fill color using macro
    By jousterlj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2011, 01:50 PM
  6. Delete rows based on fill color
    By schueyisking in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-22-2008, 05:54 AM
  7. Delete Rows Based On Color
    By Tommyweather in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2008, 04:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1