Protected sheet and clear macro NOT working

[shebogen]

I set up a worksheet for other users to calculate the tax consequences of different divorce settlements. The users enter the cells bordered in black. The cells bordered in blue return results and are the cells I want to lock (and to do this I need to protect sheet.) I want the users to be able to clear and re-use the worksheet. So, I set up a macro that clears all black bordered cells. However, I get an error for this macro when it is run because the worksheet is locked. Suggestions?

 

[mumps]

Your macro has to unprotect the sheet at the beginning and then protect it again at the end. For example:

Sub test()
    ActiveSheet.Unprotect
        'your code here
    ActiveSheet.Protect
End Sub