BREAK THE PASSWORD OF THE SHEET IN EXCEL

-
Below steps will guide you to hack or unlock the Password of the excel Sheet


Press ALT + F11 or click on View Code in Developers Tabs
In the visual basic Enter the below Code. Do not change the code just copy paste:

Sub PasswordBreaker()
'Breaks worksheet password protection.
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
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

Now Click on the Run Button or press F5:"

Comments

Post a Comment

Popular posts from this blog

Formatting a Range of Cells In Excel VBA

-
Formatting Cells Number General Range("A1").NumberFormat = "General" Number Range("A1").NumberFormat = "0.00" Currency Range("A1").NumberFormat = "$#,##0.00" Accounting Range("A1").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)" Date Range("A1").NumberFormat = "yyyy-mm-dd;@" Time Range("A1").NumberFormat = "h:mm:ss AM/PM;@" Percentage Range("A1").NumberFormat = "0.00%" Fraction Range("A1").NumberFormat = "# ?/?" Scientific Range("A1").NumberFormat = "0.00E+00" Text Range("A1").NumberFormat = "@" Special Range("A1").NumberFormat = "00000" Custom Range("A1").NumberFormat = "$#,##0.00_);[Red]($#,##0.00)" Formatting Cells Alignment Text Alignment Horizontal The value o
Read more

Trunc() Function

-
Image
Trunc() Function The Excel TRUNC function returns a truncated number based on a given number of digits. For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3. The TRUNC function does no rounding, it simply truncates as specified. Syntax The syntax for the TRUNC function in Microsoft Excel is: =TRUNC( number, [digits] ) Parameters or Arguments number The number to truncate. digits Optional. It is the number of decimal places to display in the resulting truncated number. If this parameter is omitted, the TRUNC function will assume 0. Trunc Function Examples The following spreadsheet shows several examples of the Excel Trunc function: Formulas: A B 1 99.999 =TRUNC( A1, 1 ) 2 99.999 =TRUNC( A2, 2 ) 3 99.999 =TRUNC( A3 ) 4 99.999 =TRUNC( A4, -1 ) 5 -99.999 =TRUNC( A5, 2 ) 6 -99.999 =TRUNC( A6, -1 ) Results: A B 1 99.999 99.9 2 99.999 99.99
Read more