santoshloka
Board Regular
- Joined
- Aug 31, 2017
- Messages
- 125
is there any way to give colors for new sheets with macro?
Immediately after you add the new sheet, it is the active sheet so you can execute this line of code next (where I assume the color for the tab is red)...sheet tab only,
is it possible to give colors for multiple sheet tabs?
Sub ColorTabs()
Sheets("Sheet1").Tab.Color = 255
End Sub
Give this a try...List,Report sheet tab names,your code not working @mumps
Sub ColorListAndReportTabs()
Dim WS As Variant
For Each WS In Array("List", "Report")
Sheets(WS).Tab.Color = vbRed
Next
End Sub