How to use VBAs on password protected sheets and workbook?

Hi all,

Hope all is well.

Attached file contains different macros which were running perfect as long as the sheets were not protected.

I have now protected VBA, all sheets and workbook with password Abc@123 thus leading to some errors.

Can someone please modify VBA so as to work on password protected sheets?

Also, sheet DM records contain some cells as locked and some unlocked. However, when i try entering data in an unlocked cell i.e Column C, i am asked to enter password (see attachment).

Can someone please rectify it?

Thanks in advance.