TAB COLOR

[ILProgrammer]

Hi I hope people are still talking in this group because I can't seem
to find any help on this. I am using Excel Interop and programming in
C#. I have Excel all setup and adding worksheets and everything, but
now I have a request from my users to change the tab color. Of course
they can do this manually and I was able to do it with the macro

CurrSht.Tab.ColorIndex = 4

but that doesn't work in C#. I keep getting an error about setting an
int to ColorIndex. I tried using CurrSht.Tab.Color = 4 and that does
change the tab color, but to black. No matter what number I use the
color is black.

Please anyone with some input I would appreciate it, I have been going
crazy for the last 9 hours because of a simple thing as tab color.

Thanks

[Claes Bergefall]

The Color property expects a RGB value. I couldn't find any docs exactly
what the RGB function in Excel returns but I suspect it's the same as in
GDI, i.e. an int in the form 0x00bbggrr. Setting this to the value 4 is
actually slightly red, but it will look pretty much black since the red
value is so low.

The ColorIndex property should work though. It's a just an index in a color
palette so if you can set it to 4 from inside Excel you should be able to do
the same thing from your app. What error do you get?

/claes

"ILProgrammer" <sw**********@sweettrouble.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

Hi I hope people are still talking in this group because I can't seem
to find any help on this. I am using Excel Interop and programming in
C#. I have Excel all setup and adding worksheets and everything, but
now I have a request from my users to change the tab color. Of course
they can do this manually and I was able to do it with the macro

CurrSht.Tab.ColorIndex = 4

but that doesn't work in C#. I keep getting an error about setting an
int to ColorIndex. I tried using CurrSht.Tab.Color = 4 and that does
change the tab color, but to black. No matter what number I use the
color is black.

Please anyone with some input I would appreciate it, I have been going
crazy for the last 9 hours because of a simple thing as tab color.

Thanks

[ILProgrammer]

C# using Excel Interop to get to Excel Objects

CODE USED:
NewXlsWkSht.Tab.ColorIndex = 35;

ERROR:
Cannot implicitly convert type 'int' to
'Microsoft.Office.Interop.Excel.XlColorIndex'

[Nicholas Paldino [.NET/C# MVP]]

The problem here is that you are not supposed to set it to a value
representing a color. The allowable values are:

XlColorIndex.xlColorIndexAutomatic = -4105
XlColorIndex.xlColorIndexNone = -4142

Why aren't you setting the Color property instead?

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"ILProgrammer" <sw**********@sweettrouble.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

Hi I hope people are still talking in this group because I can't seem
to find any help on this. I am using Excel Interop and programming in
C#. I have Excel all setup and adding worksheets and everything, but
now I have a request from my users to change the tab color. Of course
they can do this manually and I was able to do it with the macro

CurrSht.Tab.ColorIndex = 4

but that doesn't work in C#. I keep getting an error about setting an
int to ColorIndex. I tried using CurrSht.Tab.Color = 4 and that does
change the tab color, but to black. No matter what number I use the
color is black.

Please anyone with some input I would appreciate it, I have been going
crazy for the last 9 hours because of a simple thing as tab color.

Thanks

[ILProgrammer]

I tried the Color property of tab as well. Trouble is no matter what
value I put there the tab is black.

CurrSht.Tab.Color = 35;

Maybe I am doing something wrong.
Do I need to set the index first to Automatic and then the Color???

[ILProgrammer]

OK nothing seems to be working here.

I can't set a value -4105 or anything to XlColorIndex. Unless I am
doing it wrong, how do you set that value?

Both these produce compile errors. . .

NewXlsWkSht.Tab.ColorIndex = -4105;
Microsoft.Office.Interop.Excel.XlColorIndex.xlColo rIndexAutomatic myInd
= -4105

All I can do without getting an error at compile is . . . but I get
errors during runtime on the colorindex line

NewXlsWkSht.Tab.ColorIndex =
Microsoft.Office.Interop.Excel.XlColorIndex.xlColo rIndexAutomatic;
NewXlsWkSht.Tab.Color = 35;

Either Excel's Interop no longer lets you change the tab color, or I am
doing and missing something. Anyone have more ideas to try?? Or can
see what I am doing wrong? Like I said no matter what number I put in
NewXlsWkSht.Tab.Color the color is black.

Thanks

[ILProgrammer]

YES finally. Thank you to everyone's responses. Through all of them I
was finally able to come up with a solution. To anyone ever trying to
change the colors to the tab on an Excel worksheet using C# and the
Excel Interop here is the code.

System.Drawing.Color myCol =
System.Drawing.Color.FromArgb(204,255,204);
int Clr = myCol.ToArgb();
NewXlsWkSht.Tab.Color = Clr;