Batch protect multiple sheets

[Jasen]

Hi

Is it possible to protect all sheets in a workbook except for a select few, and for another select few within those to have row formatting enabled? Also a popup for password entry would be ideal.
Thanks for any help!

[Kenneth Hobs]

InputBox, Application.InputBox, and an EditBox userform control can be used to input a password. The latter allows a method to blind character entry.

Can you say which sheets would have no password and which ones would have a password but different protect options?

Try recording a macro to see what options you want for the two protect scenarios. UserInferface:=True allows a worksheet protect to let your code make changes without the need to unprotect, modify, and protect.