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...


    Code
    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