Unlocking & Locking multiple workbooks.

[Frankie_The_Flyer]

Thanks to the wonders of this site I have a code that looks through a selection of workbooks (held in a list in Column AZ) and returns data from selected cells in each to specific places in the Master workbook.

As the workbooks are initially protected with the code

Please Login or Register  to view this content.

to stop anyone going in and changing data, I need to be able to unlock, collect the data and then lock each as they are called up.

Question is, what needs to be added to the code below and where to achieve the unlock and lock please??

Please Login or Register  to view this content.

Many thanks in advance

Frankie

[FDibbins]

I presume you have the PW's for these other files?

[Frankie_The_Flyer]

Hi FDibbins. Yes, the Password is the same for each workbook as they are all relating to the same Master data.