I have a list of passwords that I want to apply individually to mulitple
worksheets.
The mutiple worksheets in one one workbook is accessed by numerous
individuals.
I have a separate file maintaining the worksheet names (in column "A") and
the corresponding individual passwords to each sheet (in column "B"). My
need is to loop through the listing and set the passwords for each
worksheet. When I add a worksheet or change the password for another
worksheet, I would like to use the listing to reset or add the password to
the corresponding worksheets.
How would I implement this in VBA?
I would appreciate any guidance.
Jack