tab color change
 

I have a workbook with several sheets inside of it. I would like for the tab
color to automatically change color is a condition is met. For example if on
the sheet a cell has a drop down list and by choosing one of the selections
from the drop down menu would automatically change the color of the tab for
that sheet to red for example. If this is possible can you set different
colors for the drop down list? If you choose one selection it turns green
another selection yellow, etc..

tab color change
 

You would need to do this in VBA, and then only in a version of XL that
supports colored tabs. XL 2000 and earlier do not support colored tabs.

See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm

Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of
the way down.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cac1966" wrote:

I have a workbook with several sheets inside of it. I would like for the tab
color to automatically change color is a condition is met. For example if on
the sheet a cell has a drop down list and by choosing one of the selections
from the drop down menu would automatically change the color of the tab for
that sheet to red for example. If this is possible can you set different
colors for the drop down list? If you choose one selection it turns green
another selection yellow, etc..

tab color change
 

I read this section maybe I didnt fully understand it. It told me how to
change the colors of the tabs but I didnt see anything mentioned about
automatically changing color of tabs if a condition was met in a worksheet.
Any comments would be appreciated.


"Dave F" wrote:

You would need to do this in VBA, and then only in a version of XL that
supports colored tabs. XL 2000 and earlier do not support colored tabs.

See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm

Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of
the way down.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cac1966" wrote:

I have a workbook with several sheets inside of it. I would like for the tab
color to automatically change color is a condition is met. For example if on
the sheet a cell has a drop down list and by choosing one of the selections
from the drop down menu would automatically change the color of the tab for
that sheet to red for example. If this is possible can you set different
colors for the drop down list? If you choose one selection it turns green
another selection yellow, etc..

tab color change
 

Well, a quick google search turns up this:
http://groups.google.com/group/micro...c3563fab3fc197

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cac1966" wrote:

I read this section maybe I didnt fully understand it. It told me how to
change the colors of the tabs but I didnt see anything mentioned about
automatically changing color of tabs if a condition was met in a worksheet.
Any comments would be appreciated.


"Dave F" wrote:

You would need to do this in VBA, and then only in a version of XL that
supports colored tabs. XL 2000 and earlier do not support colored tabs.

See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm

Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of
the way down.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cac1966" wrote:

I have a workbook with several sheets inside of it. I would like for the tab
color to automatically change color is a condition is met. For example if on
the sheet a cell has a drop down list and by choosing one of the selections
from the drop down menu would automatically change the color of the tab for
that sheet to red for example. If this is possible can you set different
colors for the drop down list? If you choose one selection it turns green
another selection yellow, etc..

tab color change
 

Thanks Dave!

"Dave F" wrote:

Well, a quick google search turns up this:
http://groups.google.com/group/micro...c3563fab3fc197

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cac1966" wrote:

I read this section maybe I didnt fully understand it. It told me how to
change the colors of the tabs but I didnt see anything mentioned about
automatically changing color of tabs if a condition was met in a worksheet.
Any comments would be appreciated.


"Dave F" wrote:

You would need to do this in VBA, and then only in a version of XL that
supports colored tabs. XL 2000 and earlier do not support colored tabs.

See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm

Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of
the way down.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cac1966" wrote:

I have a workbook with several sheets inside of it. I would like for the tab
color to automatically change color is a condition is met. For example if on
the sheet a cell has a drop down list and by choosing one of the selections
from the drop down menu would automatically change the color of the tab for
that sheet to red for example. If this is possible can you set different
colors for the drop down list? If you choose one selection it turns green
another selection yellow, etc..