Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there, I'm trying to change the tab colour in a workbook that was written
by someone else. The sheet is not protected, but when I right click on the tab the "colour" option is greyed out, so can't be used. I've looked through the various places in OPTIONS but can't see anything. There must be something else to look for................ Regards, Brett. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You said the Worksheet is not protected, but is the Workbook protected?
TOOLS--PROTECTION--"Unprotect Workbook..." HTH Elkar "Brettjg" wrote: Hi there, I'm trying to change the tab colour in a workbook that was written by someone else. The sheet is not protected, but when I right click on the tab the "colour" option is greyed out, so can't be used. I've looked through the various places in OPTIONS but can't see anything. There must be something else to look for................ Regards, Brett. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Gotcha. Thanks Elkar
"Elkar" wrote: You said the Worksheet is not protected, but is the Workbook protected? TOOLS--PROTECTION--"Unprotect Workbook..." HTH Elkar "Brettjg" wrote: Hi there, I'm trying to change the tab colour in a workbook that was written by someone else. The sheet is not protected, but when I right click on the tab the "colour" option is greyed out, so can't be used. I've looked through the various places in OPTIONS but can't see anything. There must be something else to look for................ Regards, Brett. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Whole sheet colour changed?? How to fix | New Users to Excel | |||
Change colour of cells when content is altered/changed | Excel Discussion (Misc queries) | |||
Change colour of data when changed | Excel Discussion (Misc queries) | |||
Changed worksheet file (Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2003 Find and Replace is changed to previovois ver.-awful!! | Excel Discussion (Misc queries) |