Are these are passwords to open the file?

Or are they passwords to unprotect the workbook?

or are they passwords to unprotect sheets within the workbook?

Or a combination of any of them???

If they're passwords to open the file, you could use a macro that would open the
30 "sending" workbooks first (supplying the password in the code) and then
finally open your total workbook last.

If they're passwords to unprotect the workbooks, you could do the same kind of
in code. Same with the worksheets. But you'll have to know the passwords for
the code to work.

And the code is different for each of those, so it wouldn't be worth the trouble
of guessing what one you meant.

Cindyt wrote:

I have 30 workbooks that are protected by way of the security tab on the
Tools menu. All have different passwords, assigned by their "owner". These
workbooks are totaled on another monthly sheet, which is also protected in
the same way.

When I open the Total Monthly worksheet and it attempts to update the
information, it asks me to unlock the 30 workbooks - one at a time - which is
entirely too much work to keep up with all of these different passwords.

Is there anyway to circumvent this?

Thanks for any help.

--

Dave Peterson