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.

Hi jolivanes,

Appreciate your response.

I tried changing VBA but it didn't work out and therefore dropped this post.

hi,

can someone please help with the correct VBA

@jolivanes

Thanks for your response.

Tried above code, but still resulting in error