S Samuel Thomsen Jul 24, 2003 #1 I've been messing around trying to color tabs. Anybody have a suggestion. SAM
C Chip Pearson Jul 24, 2003 #2 Samuel, This can be done only in Excel 2002 and later. To change the color of the tab, right click the tab and choose Tab Color, or go to the Format menu, choose Sheet, then Tab Color. In VBA, this code will color the tab red: ActiveSheet.Tab.ColorIndex = 3 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
Samuel, This can be done only in Excel 2002 and later. To change the color of the tab, right click the tab and choose Tab Color, or go to the Format menu, choose Sheet, then Tab Color. In VBA, this code will color the tab red: ActiveSheet.Tab.ColorIndex = 3 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
