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!
Printable View
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!
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.