Run-Time Error

[CBW]

We have a little program we run in Excel and it was created in Excel 97. We
all have Windows XP and Office 2000 or 2003.

When I go in to make a change, for example I click a button named "New" to
change a dollar amount. After I change the dollar amount I click another
button named "Submit". It's when I click the submit button that I get the
error message.

Run-Time error '1004':
Unable to set the ColorIndex property of the Font Class

When I click on the "Debug" button it takes me to where the error is but I
don't know how to correct it. Below is a sample of where the "Debug" takes
me in Visual Basic.

Sheets("Rate Sheet").Range("H18:H82").Font.ColorIndex = 11

Can I just change the "=" to another color value and how do I found out what
the color value number is?

Thanks!

[mrice]

Are any of the cells in that range protected? This could cause an error like this.

To get a spreadsheet with all the 56 colours use the following macro.

Sub GenerateColours()
For N = 1 To 56
Cells(N, 1) = N
Cells(N, 2).Interior.ColorIndex = N
Next N
End Sub

[CBW]

None of the cells are protected. I think I have a temporary fix. Having
this number change colors is not a big issue and that's all it is, a number
that changes to red when changed. If you accept this number then it changes
back to black. I just didn't know the color values. This really helps,
thanks.
CBW

"mrice" wrote:

>
> Are any of the cells in that range protected? This could cause an error
> like this.
>
> To get a spreadsheet with all the 56 colours use the following macro.
>
> Sub GenerateColours()
> For N = 1 To 56
> Cells(N, 1) = N
> Cells(N, 2).Interior.ColorIndex = N
> Next N
> End Sub
>
>
> --
> mrice
>
>
> ------------------------------------------------------------------------
> mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
> View this thread: http://www.excelforum.com/showthread...hreadid=532731
>
>

[CBW]

I found out that when this rate is changed it changes rates throughout the
workbook and I won't know what has changed if I don't have the rate in a
different color.

"CBW" wrote:

> We have a little program we run in Excel and it was created in Excel 97. We
> all have Windows XP and Office 2000 or 2003.
>
> When I go in to make a change, for example I click a button named "New" to
> change a dollar amount. After I change the dollar amount I click another
> button named "Submit". It's when I click the submit button that I get the
> error message.
>
> Run-Time error '1004':
> Unable to set the ColorIndex property of the Font Class
>
> When I click on the "Debug" button it takes me to where the error is but I
> don't know how to correct it. Below is a sample of where the "Debug" takes
> me in Visual Basic.
>
> Sheets("Rate Sheet").Range("H18:H82").Font.ColorIndex = 11
>
> Can I just change the "=" to another color value and how do I found out what
> the color value number is?
>
> Thanks!
>