Pete
08-14-2008, 04:11 AM
See attached snippet
Hi Experts
Need to modify the VBA Code as shown below so that all current worksheet are unprotected and password protected using the current password.....
BUT the following two worksheet are unprotected and password protected using a different password.
So for the worksheet(s) "shtLTD", "shtPricing"
i want to change the vba code so that
sht.Unprotect Password:=Sheet11.Range("C2").value also includes
sht.Unprotect Password:=includes =sheet11.Range("D2").value = "shtLTD"
sht.Unprotect Password:=includes =sheet11.Range("D3").value = "shtPricing
Hi Experts
Need to modify the VBA Code as shown below so that all current worksheet are unprotected and password protected using the current password.....
BUT the following two worksheet are unprotected and password protected using a different password.
So for the worksheet(s) "shtLTD", "shtPricing"
i want to change the vba code so that
sht.Unprotect Password:=Sheet11.Range("C2").value also includes
sht.Unprotect Password:=includes =sheet11.Range("D2").value = "shtLTD"
sht.Unprotect Password:=includes =sheet11.Range("D3").value = "shtPricing