unlocking multiple worksheets

I would like to be able to unlock multiple worksheets
withing a workbook.

I have a workbook compiled using copied worksheets from a
number of workbooks. There are about 150 sheets, which
are all locked and have the same password. Is it possible
to globally unlock them?

Your assistace would be appreciated.

Regards

Peter L.

Hi
use some code like

dim unlock_all()
dim wks as worksheet
on error resume next
for eack wks in worksheets
wks.unprotect password:="your password"
next
on error goto 0
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

"Peter Loveridge" schrieb im
Newsbeitrag ...
I would like to be able to unlock multiple worksheets
withing a workbook.

I have a workbook compiled using copied worksheets from a
number of workbooks. There are about 150 sheets, which
are all locked and have the same password. Is it possible
to globally unlock them?

Your assistace would be appreciated.

Regards

Peter L.

Frank

Thanks very much for your response. I will try it as soon
as I get a break, and post again.

Regards
Peter
Sydney
Australia

-----Original Message-----
Hi
use some code like

dim unlock_all()
dim wks as worksheet
on error resume next
for eack wks in worksheets
wks.unprotect password:="your password"
next
on error goto 0
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

"Peter Loveridge"
schrieb im
Newsbeitrag ...
I would like to be able to unlock multiple worksheets
withing a workbook.

I have a workbook compiled using copied worksheets from
a
number of workbooks. There are about 150 sheets, which
are all locked and have the same password. Is it
possible
to globally unlock them?

Your assistace would be appreciated.

Regards

Peter L.

.