[mso] Re: Highlight worksheet tabs in Excel
- From: "Dian D. Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 21 Sep 2005 18:21:41 -0500
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
*************************************************************
Other related posts:
