Try xlColorIndexNone

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sisilla" wrote in message
...
Hello There,

My macro works fine when my sheet is unprotected, but I
receive a prompt to debug when I protect the sheet. I have
unlocked the cells that have to be edited by the macro, so
I know that's not the problem. My macro changes the fill
color of some cells. When I try to run it Excel gives me
this error:

Run-time error '1004':
Unable to set the ColorIndex property of the Interior class

I am prompted to debug this line of code:
Selection.Interior.ColorIndex = xlNone

I am on Excel XP, VB6.3, and Windows 2000. I appreciate
any help.

Thnaks,
Sisilla