is this possible in VB or by a macro?
tks jan

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

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

Hi, here is an interesting one in Ivan F Moala's site.
http://xcelfiles.homestead.com/Excel01_02.html

--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


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

thank you, but im using xcell from office97.
i was thinking of grouping sheets.
reg jan
"Colo" skrev i melding
...
Hi, here is an interesting one in Ivan F Moala's site.
http://xcelfiles.homestead.com/Excel01_02.html

--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


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