instead of using all the sheets name, what code to just choose all sheets
it this the code ?Code:Sheets("Sheet3").Tab.ColorIndex = 46 Sheets("Sheet2").Tab.ColorIndex = 46 Sheets("Sheet1").Tab.ColorIndex = 46
Code:worksheets.Tab.ColorIndex = 46
instead of using all the sheets name, what code to just choose all sheets
it this the code ?Code:Sheets("Sheet3").Tab.ColorIndex = 46 Sheets("Sheet2").Tab.ColorIndex = 46 Sheets("Sheet1").Tab.ColorIndex = 46
Code:worksheets.Tab.ColorIndex = 46
Bookmarks