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.