Programmatically Protect/Unprotect Sheets with VBA

[learning_vba]

Good Morning,

I have a workbook with many sheets that contain a mixture of cells that are locked and unlocked. Is it possible to programmatically Protect/Unprotect a given sheet with a pass word? Basically, I have macros that update locked cells, but the macro fails b/c the cells are locked. I need to be able to unlock the sheet via VBA, execute my macro and the relock the protected cells. The password can be in the VBA code b/c I will have the VBA project locked for viewing.

I recorded a macro of me doing what the locking part of it, but I dont see how to insert a password. Here is the recorded code:

Please Login or Register  to view this content.

What I would like is something like this:

Please Login or Register  to view this content.

Thank you for any help that can be provided

learning_vba

[learning_vba]

I have found a solution which works for my needs. Instead on protecting/unprotecting sheets, I can use the following line in my For Each ws loop:

ws.Protect Password:="abc123", UserInterfaceOnly:=True

Apparently this only protects cells from the user interface, but on the VBA side of things protected cells can be modified

Thank you