VBA Protect/Unprotect worksheet

Hi

I have a small problem.

In my vba code I use the following.

ActiveSheet.Unprotect Password = "1234" and
ActiveSheet.Protect Password = "1234"

Which Works just fine.

But when I want to unprotect manually it says the password is incorrrect.

Any idea why?

This is because your password is really "Falsk". The code is incorrect - it passes an expression rather than a named argument. Change the code to this:

Please Login or Register  to view this content.

Try this VBA

place in a Module

Please Login or Register  to view this content.

Then place this in your sheet

Please Login or Register  to view this content.

Thanks a lot, that solved my problem.