coloring a tab

  • Thread starter Thread starter Jan Eikeland
  • Start date Start date
Jan,

This is possible only in Excel 2002 and later, and not in earlier
versions. Use code like the following:

Worksheets(1).Tab.ColorIndex = 3

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
is this possible in VB or by a macro?
Click to expand...

Do like I did: record a new macro & do what you wanna do, and you'll
end up with something like:

Sheets("Sheet1").Select
ActiveWorkbook.Sheets("Indtast").Tab.ColorIndex = 6


regards /Snedker
 
thank you, but im using xcell from office97.
i was thinking of grouping sheets.
reg jan
 
Back
Top