Protect Sheet with password through VBA
Perfect. Thank you ...
"JE McGimpsey" wrote:
one way:
Const sPWORD As String = "drowssap"
Sheets("Sheet1").Protect Password:=sPWORD
Sheets("Sheet1").Unprotect Password:=sPWORD
In article ,
"bill_morgan_3333" wrote:
Is there a way to protect and unprotect (with a password) an Excel 2000 sheet
through VBA? I know the syntax for doing this without a password, but can it
be done with a password?
Thanks ...
Bill Morgan
|