If there are multiple sheets needed to protect and allow users to sort and filter, you can apply Protect Worksheet utility of Kutools for Excel to protect multiple sheets at one ease go to free try Kutools for Excel first, and then go to apply the operation according below steps. Unprotect Chr (i ) & Chr (j ) & Chr (k ) & _Ĭhr (l ) & Chr (m ) & Chr (i1 ) & Chr (i2 ) & Chr (i3 ) & _Ĭhr (i4 ) & Chr (i5 ) & Chr (i6 ) & Chr (n ) If ActiveSheet. Then the users can sort and filter in this protected sheet. In many versions of XL, bypassing protection is as easy as selecting the entire worksheet, copying it and pasting it to a new worksheet. Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66 : For j = 65 To 66 : For k = 65 To 66 For l = 65 To 66 : For m = 65 To 66 : For i1 = 65 To 66 For i2 = 65 To 66 : For i3 = 65 To 66 : For i4 = 65 To 66 For i5 = 65 To 66 : For i6 = 65 To 66 : For n = 32 To 126ĪctiveSheet. Again, it doesnt matter what your original password is, one of those 194K strings will unlock your sheet or workbook. Example: excel vba unlock sheet without password Sub PasswordBreaker ( ) 'Breaks worksheet password protection. If you open any workbook and select any cell in a randomly selected worksheet, you will note that the cell is locked.
