On Wed, 17 Dec 2003 18:42:29 GMT, "Jan Eikeland"
wrote:

is this possible in VB or by a macro?

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