Modify VBA to show "VeryHidden" tabs that are yellow

  • Can anyone offer advice on how I can change the below VBA to unhide "VeryHidden" tabs that are Yellow color?


  • Hello,


    You could test following modification for your instruction shown on line # 11


    Code
    1. If ws.Visible = xlSheetVeryHidden Then ws.Visible = xlSheetVisible


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Like this


  • If you only want to unhide tabs that are both yellow and veryhidden (your current code will unhide them if they are yellow, regardless of what kind of hidden they are), you just need a small tweak:


    Code
    1. If ws.Tab.Color = TABCOLOR and ws.visible = xlsheetveryhidden Then

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Hello,


    Do not hesitate to share with the Forum your final thoughts about how you have implemented your solution ...


    Very useful for all Future readers ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)