how do I change the color on a worksheet tab using excel mac 2004

J

J15491

I am trying to change the color of my worksheet tabs, but can't find any info
on ho to do it using a mac
 
J

Jacob Skaria

Right click on the Sheet tab and select a color from 'Tab Color'.

If you are looking for a macro..
ActiveWorkbook.Sheets("Sheet1").Tab.Color = vbRed

If this post helps click Yes
 
J

Jacob Skaria

Right click on the Sheet tab and select a color from 'Tab Color'.

If you are looking for a macro..
ActiveWorkbook.Sheets("Sheet1").Tab.Color = vbRed

If this post helps click Yes
 

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

Excel 2004 Mac question 2
How do I change the font color of my sheet tabs? 1
Worksheet Merge Excel Mac 2004 1
(unwanted) new worksheet 3
Forms that Populate Excel Worksheet? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I save an Excel 97-2003 version or 2007 version for Mac 200 1
Excel 2004 for Mac drawing tool 4

Top