Unprotect worksheet : Worksheet Protection « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Worksheet Protection

Unprotect worksheet

 

Sub UnprotectWS()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Protection")
    ws.Unprotect "Excel2003"
End Sub








Related examples in the same category

1.Add protection to Worksheet
2.Protect Sheet
3.Show Protection Properties
4.remove user
5.Remove user edit range
6.Add user edit range
7.Formulas Protection
8.Protecting Worksheet Assets with the Protect Method