Sprinks, are you saying you want to change the passwords of all the
worksheets in all the workbooks in a folder and its subfolder? How
complicated this will be depends on 1. Do all the worksheets in each
workbook have the same password? 2. Do all the worksheets in ALL the
workbooks have the same password? James
Sprinks wrote:
We have a number of worksheets containing sensitive data that are protected
by password. Periodically, the firm's principal requests that we change the
password for each. As there are a relatively large number of sheets to
change, is there a means by which we could update the password for all sheets
in a folder & its subfolders?

Thank you.
Sprinks