Error 1004: Unable to set colorindex property ...

[jcarneir]

I write a module in excel that works perfectly in excel 2000.

If I open the workbook in excel 97 I get the run-time error 1004: "Unable to set colorindex property of the font class.

The instruction is:
ActiveSheet.Cells(4, 3).Font.ColorIndex = 1

What's wrong in 97.
BTW the workbook is protected but I don't need unprotect it to change the colorindex property. If I tried to use the method unprotect I get an error too.

Any clue??

 

[jcarneir]

Another fact: The code is triggered by clicking a command button.

 

[xlbo]

Make sure the take focus on click property of the command button is set to false Rgds
~Geoff~

 

[jcarneir]

I change this property and the code run in excel 97.

Thanks