Home
Forums
VBA macros
Tutorials
Downloads
Open XL
Jobs
About Us
Color all sheet tabs in the workbook
Code:
Sub
ColorSheetsTabs()
Dim
mySheet
As
Worksheet
Dim
i
As
Integer
For Each
mySheet
In
ActiveWorkbook.Sheets
mySheet.Tab.ColorIndex = 3 + i
i = i + 2
Next
End Sub
NIGHTFLARE
said...
Very simple and nice trick..
thank you
July 16, 2009 5:13 PM
Post a Comment
Newer Post
Older Post
Home
Very simple and nice trick..
thank you
Post a Comment