Assign COlors to Sheet Tabs

P

PMO

How do I assign a color using VBA to a sheet Tab. I have looked high
and low without any luck.
 
J

JackD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to assign resources to tasks but the 'Assign Resources' is greyed out on the Resource tab. 0
Printing from Word my Inserted Pictures colors are dull and lack color 0
Address Format changed after Migration 0
Need help modifying code 0
Using Flags with Resource Percentages 0
macOS Office365 Word 0
Save workbook without shapes 0
Match table shading (color) to Visio color/Transparency 1

Top