Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do I change the color on a worksheet tab using excel mac 2004

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default how do I change the color on a worksheet tab using excel mac 2004

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
---------------
Jacob Skaria


"J15491" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Merge Excel Mac 2004 Gene Augustin Excel Discussion (Misc queries) 1 March 8th 09 06:27 PM
How do I change the color of the MS 2007 worksheet tabs? Short ''n'' Sassy Excel Worksheet Functions 4 November 24th 08 05:19 PM
change the color of one word throughout a worksheet wfbarron Excel Worksheet Functions 3 November 19th 07 08:25 PM
I can't format 01/19/2004 to read January 19, 2004, please help!! paulonline66 Excel Discussion (Misc queries) 5 June 17th 05 04:54 AM
worksheet cell color change jimemma New Users to Excel 3 April 12th 05 11:39 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"