Command Button Code to Delete Unprotected Cells Only

Hi,

Anybody can help me make a code for command button to execute a delete command to cells in a workbook that is not protected only? I am suppose to Protect the workbook with password and with a single click of a button will automatically delete the cells which are not protected. Thanks in advance

Try

Please Login or Register  to view this content.

This will clear all unlocked cells.

This will be faster on large numbers of cells

Please Login or Register  to view this content.