Give color to sheets?

[santoshloka]

is there any way to give colors for new sheets with macro?

 

[Rick Rothstein]

Re: how to give color to sheets?

your code giving same color to both sheets
if i wan to give another color for Report sheet?

Do you have specific colors in mind (if so, what are they) or do you want any old random color assigned?

 

[santoshloka]

Re: how to give color to sheets?

rgbblue

 

[shg]

Re: how to give color to sheets?

Sub santoshloka()
  Worksheets("List").Tab.Color = RGB(255, 0, 0)     ' red
  Worksheets("Report").Tab.Color = RGB(0, 0, 255)   ' blue
End Sub

 

[Logit]

Re: how to give color to sheets?

.
Or ... the old fashion way ?

Right click the tab, select TAB COLOR ?