Clearing data in protected worksheets

[Bob Forrest]

I have a worksheet set up as a form. The sheet is protected. Most data is entered via pulldown lists in unprtected cells. I want to clear data from the cells (equivalent to starting with a blank form). Is there a simple way to wipe the sheet clear. I have written a macro, but it is messy in that I had to hightlight and delete the contents of every unprotected cell. If I sheet is edited I have to redo the Macro. Is the a macro that can clear the contents of the unprotected cells in a worksheet?

[starguy]

I have a worksheet set up as a form. The sheet is protected. Most data is entered via pulldown lists in unprtected cells. I want to clear data from the cells (equivalent to starting with a blank form). Is there a simple way to wipe the sheet clear. I have written a macro, but it is messy in that I had to hightlight and delete the contents of every unprotected cell. If I sheet is edited I have to redo the Macro. Is the a macro that can clear the contents of the unprotected cells in a worksheet?

Record a macro for following activities.
Select the cells you want to clear (Ctrl+Click on cell) and clear them all.