Protect Project Causes Error

[natepen]

Hello,
I've been protecting my workbook so that only certian cells can be used by the user and when they hit enter it will automatically bring them down the the next cell so they can enter info there. The only problem is that I have a refresh button that I made with macros and when i protect the information i'm getting an error saying
Run-time error "1004"
Unable to set the colorindex of the font class
Can anyone help me fix this?
Thanks
Nate

[Loz]

You probably need your macro code to be nested between Activesheet.Unprotect and Activesheet.Protect statements so that the code can amend any cells.

When a sheet is protected, even access to some of the formatting attributes of unprotected cells is still restricted for the user and macros.