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

  • Thread starter Thread starter J15491
  • Start date Start date
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
 
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
 
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
 
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

Excel 2004 Mac question 2
How do I change the font color of my sheet tabs? 1
How to filter rows data based on background color of individual cells 1
Color differences in Mac Excel 2
Excel VBA 1
Forms that Populate Excel Worksheet? 1
Excel 200 - changing tab colors 1
How can I activate tab colors? 1

Back
Top