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:
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.