Pairs.PasswordList Property

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference > Pairs Object > Properties >

Pairs.PasswordList Property

Previous pageReturn to chapter overviewNext page

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




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