• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. H

    I need a VBA script that automatically locks cells

    Private Sub Worksheet_Change(ByVal Target As Range) If WorksheetFunction.IsText(Target.Value) Then ActiveSheet.Unprotect "MyPassword" 'Delete if no password needed Target.Locked = True ActiveSheet.Protect "MyPassword" End If End Sub tryed that code but it still locks all cells tryed 6...
  2. H

    I need a VBA script that automatically locks cells

    Im still needing a macro because using the protect sheet feature doesnt do all i need I need cells to automatically lock once data is imput but still allow people to imput text on the cells that have no text in yet
  3. H

    I need a VBA script that automatically locks cells

    I should have also put that I need it so once text is inputted the cell locks itself {after saving or some other action} So previous boxes cant be overwritten
  4. H

    I need a VBA script that automatically locks cells

    I have a excel sheet that multiple people use that is used for imputting batch numbers and the like the issue is people keep imputting data into previous cells and messing up data I need only cells with text in to be locked and the cells cells to be unlocked so people can still add data to the...
Back
Top