How to make a clear button to clear some selected cell

[mmsamaddar]

Good Afternoon,

Need Help: I have a sheet with too many workings (formula) and I have made it password protected. In this sheet, I have some cell to edit or input some data that will make a result. The editable cell is C14:E44, D4, H14:G44, K5. But rest of the cell is fully protected. Here I need a button for clear those cell by one click in Excel 2010 or select all those cell with the help of hyperlink as Select as Delete with that one click.
Can anybody help?

Regards,
Madhu

 

[Sixthsense]

Sub ClearData()
    Range("C14:E44, D4, H14:G44, K5").ClearContents
End Sub

 

[mmsamaddar]

Works like charm, what I required.

Thanks,
Madhu