TAB COLOR

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Quantcast