I created a worksheet and locked the cells with formulas so users could input data, but not alter cells with formulas that show the results of their input. I then recorded a macro to clear all user input cells. However, when I tested the macro after the workbook was protected again, there is an error because of the protected status. As a curious note, all the cells that I am clearing are user input cells so they are not locked.