Consulting

Results 1 to 2 of 2

Thread: Batch protect multiple sheets

  1. #1
    VBAX Regular
    Joined
    Oct 2015
    Posts
    13
    Location

    Question Batch protect multiple sheets

    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!

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •