coloring a tab

  • Thread starter Thread starter Jan Eikeland
  • Start date Start date
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
 
is this possible in VB or by a macro?
Click to expand...

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
 
thank you, but im using xcell from office97.
i was thinking of grouping sheets.
reg jan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help changing Keyboard Shortcut assigned to Excel Macro 2
Excel Tooltip on listview in a VBA for Excel 1
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
importing tabs/sheets only from the currently open files 1
Open TXT file 2
Data Validation Link to Color Coating 1
Help Needed, May have bitten off more than I can chew 35
Advanced filter on last months results 6

Back
Top