unlocking multiple worksheets

[Peter Loveridge]

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 Kabel]

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

 

[Peter Loveridge]

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