Sheet Protection

[Hlowmaster]

I have a macro that unprotects and re protects the sheet. But i want to have a password on the sheet. as well. What is the syntax or line of code for entering the password and putting it back on?

[BigBas]

Please Login or Register  to view this content.

Obviously, change the 1234 to the password

[Hlowmaster]

that works to unprotect it with the password but what about reprotecting it after the macro is finished? like this in example

Please Login or Register  to view this content.

[BigBas]

Try this:

Please Login or Register  to view this content.

[Hlowmaster]

I see.. Thanks bud i appreciate it