Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Protects the myWorksheet worksheet with the same password but allows the formatting of cells and allows the sorting of unlocked cell
Sub protect()
    ActiveWorksheet.Protect Password:="pass", AllowFormattingCells:=True, _
        AllowSorting:=True
End Sub