Results 1 to 4 of 4

Lock and Hide Sheets based on Tab Color

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    Salem, OR
    MS-Off Ver
    Excel 2010
    Posts
    7

    Lock and Hide Sheets based on Tab Color

    Hello,

    I'm looking for a macro solution to "Close" (Hide) Sheets based on the Color of the tab.

    In a workbook with colored tabs, where BLACK tabs are "Raw Data", GREEN are Graphical tabs, etc., I am intending for the macro, when activated, will (for example) lock and hide all RED tabs.

    I thought that this would work:

     With ActiveWorkbook.Sheets
           If ThemeColor = xlThemeColorLight1 Then
                    '.TintAndShade = 0
                ActiveWorkbook.Sheets.Visible = False
            End If
        End With
    ...but, it does nothing. Any ideas on how to make this work?
    Last edited by arlu1201; 07-01-2013 at 01:54 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1