ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab color in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/55445-tab-color-excel-2003-a.html)

slinge

Tab color in Excel 2003
 
I set up all my worksheet tabs with color. But for some reason when I go to
format and then sheet, my 'tab color' is greyed out.

Jim Rech

Tab color in Excel 2003
 
I see this graying out only when the workbook is protected (Tools,
Protection) or the workbook is shared (Tools, Share Workbook).

--
Jim
"slinge" wrote in message
...
|I set up all my worksheet tabs with color. But for some reason when I go to
| format and then sheet, my 'tab color' is greyed out.



slinge

Tab color in Excel 2003
 
Thank you Jim but the worksheet is not protected. It is a shared worksheet
though if this helps in finding a solution.

"Jim Rech" wrote:

I see this graying out only when the workbook is protected (Tools,
Protection) or the workbook is shared (Tools, Share Workbook).

--
Jim
"slinge" wrote in message
...
|I set up all my worksheet tabs with color. But for some reason when I go to
| format and then sheet, my 'tab color' is greyed out.





All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com