Write a macro that will repeat the unprotect. Assign the macro to a key so
all you need do is press a key for each sheet.

"ExcelPC" wrote:

I have a worksheet with 12 tabs. The sheets in each tab are protected by the
same password.

I have tried selecting all the tabs (similar to making changes on all sheets
in tabs) and tried to unprotect all the sheets simultaneously - be have been
unsuccessful.

I have to do this for many files, hence a quicker/more efficient way is
desireable.