Looping this code

Hi all,

I've been given a set of worksheets I need to unlock in order to make them more printable.

Currently I have:

PHP Code: 

Code deleted 


Currently this unlocks the password and provides whatever random assortment of keys has been used as a password, however, for ease of use I want to loop the code around for every sheet in the workbook and have it unlock all the sheets in the workbook.

Is this doable?

I tried a standard looping method, but the MsgBox's require OK'ing, so this stopped it working.

Thanks all.