[mso] Re: Highlight worksheet tabs in Excel

  • From: Joyce West <joywestuk@xxxxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Thu, 22 Sep 2005 20:53:06 +0100 (BST)

Thanks Dian, I suspect you are right. I will have to put up with it.

Norman West


--- "Dian D. Chapman" <dian@xxxxxxxxxxxxx> wrote:

> Maybe some Excel guru knows a trick to do it, but it doesn't look like that
> was a feature in Excel 2000. The first the right-click, Tab Color shows up
> in is in XP. I was about to tell you this cos' I've used it in 2003, but
> then figured that is so easy that you probably would have found it. So I
> checked 2000 and don't see the obvious. Checking Help didn't provide any
> leads either. 
> 
> So unless someone comes up with a trick, my guess is it can't be done in
> that version. 
> 
> Dian D. Chapman, Technical Consultant
> Microsoft MVP, MOS Certified
> Editor/TechTrax Ezine
> 
> Help Katrina's Homeless Animals: http://www.mousetrax.com/pets.html
> 
> Free Tutorials: http://www.mousetrax.com/techtrax
> Optimize your business docs: http://www.mousetrax.com/consulting
> Learn VBA the easy way: http://www.mousetrax.com/techcourses.html 
> 
> 
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
> Of Joyce West
> Sent: Wednesday, September 21, 2005 3:34 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Highlight worksheet tabs in Excel
> 
> I have a workbook with with about 20 or more worksheets.
> 
> The first worksheet is the master sheet for the first section, which
> collects information from the
> next 9 worksheets, and the 10th worksheet also a master sheet for the second
> section collects info
> from the last 9 or so worksheets.
> 
> I would ideally like to highlight or colour the first and tenth worksheet
> tabs to avoid confusion
> when entering data.
> 
> I am using Office 2000 on XP Pro.
> 
> Anybody any ideas
> 
> Thanks in advance
> 
> Norman West
> 
> 
>               
> ___________________________________________________________ 
> To help you stay safe and secure online, we've developed the all new Yahoo!
> Security Centre. http://uk.security.yahoo.com
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
> 
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> 
> To Unsubscribe from this group, send an email to 
> mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
> in the subject line.
> 
> Or, visit the group's homepage and use the dropdown menu.  This will also
> allow you to change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
> 
> To be able to use the files section for sharing files with the group, send a
> request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
> with instructions.  Once you are a member of the files group, you can go
> here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.3/106 - Release Date: 9/19/2005
>  
> 
> -- 
> This email scanned and certified clean by AVG!
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 9/20/2005
>  
> 
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
> 
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> 
> To Unsubscribe from this group, send an email to 
> mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
> the subject line.
> 
> Or, visit the group's homepage and use the dropdown menu.  This will also 
> allow you to change
> your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
> 
> To be able to use the files section for sharing files with the group, send a 
> request to
> mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
> instructions.  Once you are
> a member of the files group, you can go here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
> 



                
___________________________________________________________ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: