Change Color of Sheet Tabs by Matching Cell Colors

Hi All,

I have a workbook with many sheets that have certain color tabs for certain worksheets. I have one page where the user can select a "To" and "From" color to change the colors of the tabs by changing the color of cells to match.

It seems to work well going from color to color with the following code:

Please Login or Register  to view this content.

But, when going to or from a tab with no color (ie matching it to a cell with no color), it does not work well. I tried the following code, but it still is not working well.

Please Login or Register  to view this content.

It changes the tab color to basically white, rather the the no color of "gray". Any suggestions?

Thanks,

Mark