I can't run macro when I protect the worksheet

[sepianhomo]

I am sorry if my English is poor.
I unlocked cells in the area that macro will use for calculation.
When I protect the worksheet the macro could not run.
But when I unprotect the worksheet the macro can run again.
I want to know how to protect some cells in the worksheet and also enable the macro to run.

[Sindhus]

Hi,

It depends on what you have coded in the macro. If you can share a dummy workbook with your macro, we can look into your issue.

Regards,
Sindhu