Results 1 to 3 of 3

Thread: Select tabs by color

  1. Dec 5th, 2005, 04:38 PM #1
    TommyHawk
    TommyHawk is offline

    Thread Starter
    Member
    Join Date
    Mar 2005
    Location
    Seattle
    Posts
    56

    Select tabs by color

    Can we select tabs by the "Tab Color"? I have a workbook with several dozen tabs, and using a macro, I'd like to select only the "blue" tabs (or other color), and copy them to a new file.

    I have the code to select everything and create a new file but...

    What do you think?
    Reply With Quote Reply With Quote
  2. Dec 5th, 2005, 04:56 PM #2
    john24
    john24 is offline
    Addicted Member
    Join Date
    Jan 2003
    Posts
    163

    Re: Select tabs by color

    not a great way but an idea - turn on record a new macro and then change the color of a tab and look at what excel/vba does - this should point you in the right direction
    Reply With Quote Reply With Quote
  3. Dec 6th, 2005, 07:15 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Select tabs by color

    Moved to Office Development
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width