<< Click to Display Table of Contents >> Pairs.PasswordList Property |
Returns or sets a semicolon delimited list of passwords needed to access protected sheets. String value.
expression.PasswordList
expression. A variable representing a Pairs object.
This example adds two password protected worksheet pairs.
With .Pairs
'add worksheets
.AddPair "Customer List", "Customer List"
.AddPair "Customer Profile", "Customer Profile"
'enter passwords (separated by semicolons)
.PasswordList = "abc;def"
End With