Color all sheet tabs in the workbook VBA Macro Worksheets Get link Facebook X Pinterest Email Other Apps Code: Sub ColorSheetsTabs() Dim mySheet As Worksheet Dim i As Integer For Each mySheet In ActiveWorkbook.Sheets mySheet.Tab.ColorIndex = 3 + i i = i + 2 Next End Sub Comments Unknown said… Very simple and nice trick..thank you
Comments
thank you