VB Code to protect and unprotect all sheets

[rizmomin]

Hello:

I have excel file with Jan,Feb,Mar....Dec sheets.
I need VB Code to protect & Unprotect with pw:1111.
Also need code to Freeze/Unfreeze at cell A42.

Please let me know if you have any questions.
Thanks.

Riz

[Passionit]

Hi, I think that the following code is what you're looking for:

Please Login or Register  to view this content.

Please let me know if this is the solution that you were looking for.