Protecting a sheet with a password using VBA code

Hello

I know how to manually protect a sheet with a password, but my question is this: How do I protect a certain sheet with a password using VBA code?

From my present knowledge when I say:

Please Login or Register  to view this content.

then it protects my sheet but with no password, so any user of my sheet could just unprotect it manually by going to Tools > Protect > Unprotect Sheet

Any hints?

Hi,

Please Login or Register  to view this content.

HTH
Carim

Just add another argument to the end password:="yourpassword"

I do really appreciate your quick answers, thanks a lot It worked just perfect