Tab color changes to distinguish multiple sheets chosen
 

In Excel '97, when multiple sheets were chosen to make the same change on all
of the sheets, the tab colors would be distinctive to make the user aware
that they were working on multiple sheets. This does not happen on Excel
2007, so after I have worked on the multiple sheet changes, if I forget or am
distracted, and I return to Excel, I forget that I was working on multiple
sheets, and am constantly thinking that I am working on one sheet, and thus
end up changing multiple sheets unintentionally, which has been causing me
headaches. Does anyone know about a cure?

Tab color changes to distinguish multiple sheets chosen
 

Hi,

Look at the title bar you will see the word [Group] when multiople sheets
are selected. But there is no way to change the display of the tab color
when selected, however, if you look closely the tab change shade a little.
With no color applied to the tabs, their default, selected tabs a bright
white and non-selected tabs are a dull light blue.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kibrit" wrote:

In Excel '97, when multiple sheets were chosen to make the same change on all
of the sheets, the tab colors would be distinctive to make the user aware
that they were working on multiple sheets. This does not happen on Excel
2007, so after I have worked on the multiple sheet changes, if I forget or am
distracted, and I return to Excel, I forget that I was working on multiple
sheets, and am constantly thinking that I am working on one sheet, and thus
end up changing multiple sheets unintentionally, which has been causing me
headaches. Does anyone know about a cure?

Tab color changes to distinguish multiple sheets chosen
 

Shane,
The only change of tab color that happens on my computer is the first sheet
(which becomes bolded text) of the series. The rest of the sheets within the
Group look as the same as the ones that are not in the group. The color of
my tabs are defaulted to Gray and stay as such when selected. Your comment
about the Group is helpful, but I tend not to look up there as often, but if
there is no other distinctions in the tabs, I will have to make it a habit to
look there.

Thanks so much for your feedback!

"Shane Devenshire" wrote:

Hi,

Look at the title bar you will see the word [Group] when multiople sheets
are selected. But there is no way to change the display of the tab color
when selected, however, if you look closely the tab change shade a little.
With no color applied to the tabs, their default, selected tabs a bright
white and non-selected tabs are a dull light blue.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kibrit" wrote:

In Excel '97, when multiple sheets were chosen to make the same change on all
of the sheets, the tab colors would be distinctive to make the user aware
that they were working on multiple sheets. This does not happen on Excel
2007, so after I have worked on the multiple sheet changes, if I forget or am
distracted, and I return to Excel, I forget that I was working on multiple
sheets, and am constantly thinking that I am working on one sheet, and thus
end up changing multiple sheets unintentionally, which has been causing me
headaches. Does anyone know about a cure?