tab color disabled
 

The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

Answer: tab color disabled
 

Hi there! I'm sorry to hear that you're having trouble with the 'Tab Color' menu item in Excel. Here are a few things you can try to enable it again:

1. Check if the worksheet is protected: If the worksheet is protected, you won't be able to change the tab color. To check if the worksheet is protected, go to the 'Review' tab and see if the 'Unprotect Sheet' button is enabled. If it is, click on it and enter the password (if there is one) to unprotect the sheet.
   
2. Check if the workbook is shared: If the workbook is shared, you won't be able to change the tab color. To check if the workbook is shared, go to the 'Review' tab and see if the 'Share Workbook' button is enabled. If it is, click on it and uncheck the 'Allow changes by more than one user at the same time' option.
   
3. Check if the workbook is in Compatibility Mode: If the workbook is in Compatibility Mode, some features may be disabled, including the 'Tab Color' menu item. To check if the workbook is in Compatibility Mode, go to the 'File' tab and see if the 'Compatibility Mode' message is displayed. If it is, click on it and select 'Convert' to convert the workbook to the latest file format.
   
4. Check if the worksheet is selected: If the worksheet is not selected, you won't be able to change the tab color. To select the worksheet, click on the tab name once to activate it.
   
5. Check if the worksheet is minimized: If the worksheet is minimized, you won't be able to change the tab color. To maximize the worksheet, click on the 'Restore Down' button (the middle button between the minimize and close buttons) on the top right corner of the Excel window.

I hope one of these solutions works for you!

tab color disabled
 

Is the workbook protected?

"Julianne" wrote:

The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

I don't know how to determine if my workbook is protected.

"Sean Timmons" wrote:

Is the workbook protected?

"Julianne" wrote:

The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

Go To Tools - Protection.

If any of them say unprotect, you have protection on. Click on that option
to unprotect it.

Alternately, therer could be some sort of Macro or VB in the background, but
I don't even want to venture into that territory in the event that it could
od more harm than good.

"Julianne" wrote:

I don't know how to determine if my workbook is protected.

"Sean Timmons" wrote:

Is the workbook protected?

"Julianne" wrote:

The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

Originally was shared on a network drive. But downloaded a copy to my own
hard drive and still can't modify tab color.

"Peo Sjoblom" wrote:

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

By shared, he means, if you look at the file name in your title bar does is
say (shared) to the very right?

If so, go to Tools - Share Workbook and remove the checkmark. You'll get a
prompt about saving. Click OK.

"Julianne" wrote:

Originally was shared on a network drive. But downloaded a copy to my own
hard drive and still can't modify tab color.

"Peo Sjoblom" wrote:

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

You and Peo Sjoblom are onto the problem, I believe, the only option
available under menu item 'Protection' is 'Protect Shared Workbook'
I think I'm ready to accept that I can't change the tab color and move on.

Thanks very much for your help!


"Sean Timmons" wrote:

Go To Tools - Protection.

If any of them say unprotect, you have protection on. Click on that option
to unprotect it.

Alternately, therer could be some sort of Macro or VB in the background, but
I don't even want to venture into that territory in the event that it could
od more harm than good.

"Julianne" wrote:

I don't know how to determine if my workbook is protected.

"Sean Timmons" wrote:

Is the workbook protected?

"Julianne" wrote:

The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

That's it! Thanks!
Tabs are now color-coded to content and my obsessive tendencies are satisfied!


"Sean Timmons" wrote:

By shared, he means, if you look at the file name in your title bar does is
say (shared) to the very right?

If so, go to Tools - Share Workbook and remove the checkmark. You'll get a
prompt about saving. Click OK.

"Julianne" wrote:

Originally was shared on a network drive. But downloaded a copy to my own
hard drive and still can't modify tab color.

"Peo Sjoblom" wrote:

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

You can always just copy the entire worksheet and paste into a new workbook.
This will get aroudn all the craziness...

"Julianne" wrote:

You and Peo Sjoblom are onto the problem, I believe, the only option
available under menu item 'Protection' is 'Protect Shared Workbook'
I think I'm ready to accept that I can't change the tab color and move on.

Thanks very much for your help!


"Sean Timmons" wrote:

Go To Tools - Protection.

If any of them say unprotect, you have protection on. Click on that option
to unprotect it.

Alternately, therer could be some sort of Macro or VB in the background, but
I don't even want to venture into that territory in the event that it could
od more harm than good.

"Julianne" wrote:

I don't know how to determine if my workbook is protected.

"Sean Timmons" wrote:

Is the workbook protected?

"Julianne" wrote:

The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

You have to remove the share under toolsshare workbook and clear the
checkmark from
"allow changes by more than one user etc."

Only other option would be if the workbook is protected but that is less
likely IMO

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
Originally was shared on a network drive. But downloaded a copy to my own
hard drive and still can't modify tab color.

"Peo Sjoblom" wrote:

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when
I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.

tab color disabled
 

Give it up for Peo.

Now we can all sleep well!

"Julianne" wrote:

That's it! Thanks!
Tabs are now color-coded to content and my obsessive tendencies are satisfied!


"Sean Timmons" wrote:

By shared, he means, if you look at the file name in your title bar does is
say (shared) to the very right?

If so, go to Tools - Share Workbook and remove the checkmark. You'll get a
prompt about saving. Click OK.

"Julianne" wrote:

Originally was shared on a network drive. But downloaded a copy to my own
hard drive and still can't modify tab color.

"Peo Sjoblom" wrote:

Is your workbook shared, if it is shared the
coloured tabs will be grayed out and not available
for compatibility reasons.

--


Regards,


Peo Sjoblom

"Julianne" wrote in message
...
The 'Tab Color' menu item is disabled on the Format menu and also when I
right click the tab name. There are no disabled items (Help-About
Microsoft
Office Excel--Disabled Items).
Help! Very frustrating (there is already a colored tab in this
spreadsheet
so at one time I was able to access the menu item 'tab color.')
Thanks.