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




"Jan Eikeland" wrote in message
...
is this possible in VB or by a macro?
tks jan