View Full Version : Batch protect multiple sheets

11-21-2015, 11:13 AM

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
11-23-2015, 08:31 PM
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.