How do I assign a color using VBA to a sheet Tab. I have looked high and low without any luck.
P PMO Dec 14, 2004 #1 How do I assign a color using VBA to a sheet Tab. I have looked high and low without any luck.
J JackD Dec 14, 2004 #2 This is actually the Microsoft project newsgroup, not excel, but since you asked, this works for me. Sub foo() 'turn sheet1 tab to red ActiveWorkbook.Sheets("Sheet1").Tab.ColorIndex = 3 End Sub
This is actually the Microsoft project newsgroup, not excel, but since you asked, this works for me. Sub foo() 'turn sheet1 tab to red ActiveWorkbook.Sheets("Sheet1").Tab.ColorIndex = 3 End Sub
