Color Tabs

S

Samuel Thomsen

I've been messing around trying to color tabs. Anybody have a suggestion.

SAM
 
C

Chip Pearson

Samuel,

This can be done only in Excel 2002 and later. To change the color
of the tab, right click the tab and choose Tab Color, or go to the
Format menu, choose Sheet, then Tab Color. In VBA, this code will
color the tab red:

ActiveSheet.Tab.ColorIndex = 3



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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

Printing from Word my Inserted Pictures colors are dull and lack color 0
macOS Office365 Word 0
Need help modifying code 0
Match table shading (color) to Visio color/Transparency 1
Outlook 2013-Calendar Color 0
Layout Guide color 0
Consolidation Table from Different Excel Tabs with Different Format 1
How do I convert shading to highlighting for specific colors 8

Top