coloring a tab
is this possible in VB or by a macro?
tks jan |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 06:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com