Using Array to alter multiple sheets at once

[Brelin]

I have a bit of code that sets the password protection on a specific worksheet, here it is:

Please Login or Register  to view this content.

(I have a similar one to unlock the sheets too)

The code works fine but only for one sheet, I'd like to add in more sheets but can't seem to get it to work. From what I've found I think I need the Array function in there, i.e:

Please Login or Register  to view this content.

...but it's not working, can anyone point me in the right direction please?

Thanks again

Brelin

[Colin Legg]

Hi,

Try this

Please Login or Register  to view this content.

[Brelin]

That's worked a treat

Thank you!

[Colin Legg]

Hi,

Actually, I just noticed an error in your code. These two lines should be done in a single method call:

Please Login or Register  to view this content.

Should be:

Please Login or Register  to view this content.