Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring a tab
is this possible in VB or by a macro?
tks jan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring a tab
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring a tab
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring a tab
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloring a tab
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coloring | Excel Worksheet Functions | |||
tab coloring | Excel Worksheet Functions | |||
CF List Coloring | Excel Discussion (Misc queries) | |||
Auto Coloring a Row | Excel Worksheet Functions | |||
COLORING IN CELLS | Excel Discussion (Misc queries) |