Assist to solve VBA Code Bug

Previously a developer helped us to create an automate VBA excel work sheet. But, after sometime, it run into bug. When we click on some button, it keep appeared the below error -

Run time error 1004
Method range of object / unprotected of object etc......(see below screenshot)

We need someone to assist on this. Thanks.