S
Sisilla
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
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