Results 1 to 9 of 9

[SOLVED] Need Macro to Hide & Unhide Tabs by Name or Color

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    15

    [SOLVED] Need Macro to Hide & Unhide Tabs by Name or Color

    Hi There,

    I have a workbook of about 200 tabs, 100 formatted tabs and 100 data tabs (those have "Data" in the title, and are highlighted pink: R:225, G:51, B:153)

    I need to create 2 macros to hide and unhide these tabs.

    Can someone help me with the code for this either hiding/unhiding based on name or color?

    Thanks so much!
    Last edited by lianne.cuscani; 07-01-2015 at 11:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 02-20-2015, 01:26 PM
  2. Apply a hide/unhide macro to all selected tabs
    By eric_be in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2014, 08:50 AM
  3. [SOLVED] vba code for hide/unhide tabs based on color
    By Allseasons in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 03-17-2014, 04:04 PM
  4. Macro that will hide/unhide sheets based on tab color.
    By Rixonomic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-11-2012, 02:07 PM
  5. Hide/unhide Tabs by color
    By angeljdiez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2012, 03:11 AM

Tags for this Thread

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