Posts by chipsworld

    Not an expert by any stretch, but...Found this on another page...see if this could help using with a series of "If Then" statements...

    Sub sumit()
    Dim mainworkBook As Workbook
    Set mainworkBook = ActiveWorkbook
    mainworkBook.Sheets("Main").Range("A1:C5").Value = "Locked"
    mainworkBook.Sheets("Main").Range("A1:C5").Locked = True
    ActiveSheet.Protect Password:="xx"
    End Sub

    Allows you to unlock specific range. If you use this with an "IF Then", you could unlock certain ranges of cells based upon the users input into a small user form that launches on open of the workbook?

    Just an idea