Protecting Sheet
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" |
Protecting Sheet
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" |
Protecting Sheet
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" |
Protecting Sheet
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" |
All times are GMT +1. The time now is 04:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com