How To Remove Sheet / Page Protection Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Önce Sayfa koruması olan Excel dosyası açılır, sonra makrolar bölümünden VBA düzenleyicisinin içine girilir,bir modül oluşturulur, oluşturulan modülün içine aşağıdaki kod yazılır ve çalıştırılır,... ' ****************************** KOD *************************** Sub pcwBreaker() 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 sifre = Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) ActiveSheet.Unprotect sifre If ActiveSheet.ProtectContents = False Then MsgBox "Bitti." & vbCr & "Sifre:" & vbCr & sifre Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 How to remove sheet / page protection 2 remove sheet / page protections 3 excel operators hk 4 How can I break the protection password of the sheet / page I have previously protected 5 remove the sheet / page protection password 6 Hide or show pivot table fields according to a specific criterion 7 assign protection to sheet / page tabs 8 calls sheet / page protection menus 9 calls sheet / page protection menus 10 Determining the name of the sheet / page and file containing the active cell 11 removes sheet / page protections (unencrypted) 12 remove sheet / page protection 13 userformless form menu sheet / page select 14 sheet / pages showing userform (with code without form) 15 Show progress in status bar: You can use this macro to show the progress of a macro code in the status bar. This code will add up to 5000 serial numbers to your sheet / page and will progress along with the status bar. 16 specifies in detail how many references the book contains (on new sheet / page) 17 specify the number of copies to print from the printer 18 how do I display only the working part of the sheet / page I am working on 19 find and show on sheet / page 20 specifies in detail how many formulas are in the book (on new sheet / page)