View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_10_] Stuart[_10_] is offline
external usenet poster
 
Posts: 12
Default 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"