How do I change worksheet tab colors when it is not an option,

G

Guest

2003 Excel. In workbook I have tabs colored green and I want to change the
color. When I right click on tab or go to format; tab color is not an option
I can select. Other people created the workbook. Could they have locked
something or is there some other reason why I can't change the tab color.
 
P

Paul B

Kidmac, Is the WorkBook protected? If so you will have to unprotect it to
change the tab color

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

Changing worksheet tab colors 1
Worksheet formatting (fill colors & text colors) disappeared 2
Tab color change 2
Reset Colors Option gone from Excel 2007? 2
How do I change tab color in a Workbook? Office 2000. 1
change the sheet tab color 1
Auto Chg Tab Color vs Current Month 4
Change tab color when a tab is used 1

Top