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"

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"

Stuart

I have no problem protecting via macro and unprotecting via Tools menu.

Are you positive the password you enter in either case is the same?

Do not use the quote marks when typing in the password manually.

Gord Dibben XL2002

On Tue, 4 Nov 2003 00:34:19 -0000, "Stuart" wrote:

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"

Paul

Good eyes. Missed that totally.

Gord Dibben XL2002

On Mon, 3 Nov 2003 19:53:43 -0500, "Paul B" wrote:

Stuart, try this, note the : after password

ActiveSheet.Protect password:="qwerty"

ActiveSheet.Unprotect password:="qwerty"