Protecting & Unprotecting all sheets.

[Moradyn]

Evening all, I'd like to protect and unprotect a bunch of sheets in the same workbook, in one go. so just enter password and bam, all unprotected.

Now, i'm sure this isn't a new question :wink:

I've used search and found one by Nish, on his homepage, but i need a pw to use it i think, and no answer to email.


Anyone know a Link, to something already done to do this. ?

Regards

 

[SamS]

Moradyn have a look at

http://www.mrexcel.com/wwwboard/messages/9671.html

 

[Moradyn]

Can't seem to get this to work, any info on where to put it ?

I tried putting it into a form button, but got an expected end sub message.

Regards

Mora