Thread: Clear contents on all protected sheet

Dear All,
I have a following code which is working fine on unprotected sheet.

On Error Resume Next
    Sheets("Measuring tools").[Answers].SpecialCells(xlCellTypeConstants).CLEARCONTENTS

Sheet Name: Measuring tools

Cell range : Answers which are unlocked. Some cells are with formula.

This code is not working when i protect my sheet.

Kindly advise what should amend in this code to work on protected sheet.


Thanks in advance for kind support.

Regards