Stuart, try this, note the : after password

ActiveSheet.Protect password:="qwerty"

ActiveSheet.Unprotect password:="qwerty"



--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Stuart" wrote in message
...
If I protect a sheet with the following line.

ActiveSheet.Protect password = "qwerty"

Why can't I unProtect the sheet manually from
"ToolsProtectionUnprotectSheet" then typing in the the same password?

Same ViceVersa

If i protect the sheet manually with the password "qwerty" why does the
following line cause an error

ActiveSheet.Unprotect password = "qwerty"