Worksheet Tab

M

Magne Ryholt

As we all know, a workbook may have many worksheets.
Each worksheet is (normally) represented by a sheet tab at the bottom of the
sheet.
Is there any way to (programmatically) change the appearance of these tabs
(individually) e.g. font, forecolor, backcolor etc. ?
 
C

Chip Pearson

Magne,

In Excel 2002 and 2003, you can change the color of the tab (but
not the font). Right click the tab, and choose Tab Color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
M

Magne Ryholt

Thanks, I did not mention that my question was about Excel 2000 which does
not have "Tab color" and I guess it is not possible to do programmatically
either.
 
D

David McRitchie

that's correct, unless you want to change to color of all the sheet tabs,
scroll bars etc to a different color.
 

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

Top