I need a macro to clear unprotected cells on a protected sheet. If it matters, the cells may contain values or text. Also, this is in Excel2002 which offers lots more options with respect to sheet protection. I tried creating a named range that includes every cell in the print area but once sheet protection is activated, the entire range can't be selected. I would even accept clearing every unprotected cell on the sheet. I'll just bet there's some simple code to do this.