Returns or sets a semicolon delimited list of passwords needed to access protected sheets. String value.

Syntax

expression.PasswordList

expression. A variable representing a Pairs object.

Example

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