The offline utility can be downloaded from the Income Tax e-filing portal and is the first of many ITR forms that will be made available as offline utilities. This Message is contains the password which can be used to unprotect the other sheets in the same workbook.The Income Tax Departmen recently launched an offline utility for ITR 1 and ITR 4, which can be used by taxpayers for the assessment year 2021-22. Also you would be getting a message in the pop up window. MsgBox “One usable password is ” & Chr(i) & Chr(j) & _Ĭhr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _Ĭhr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)Īnd there you go the sheet is unprotected for you now. If ActiveSheet.ProtectContents = False Then Do not change the code just copy paste:ĭim i As Integer, j As Integer, k As Integerĭim l As Integer, m As Integer, n As Integerĭim i1 As Integer, i2 As Integer, i3 As Integerĭim i4 As Integer, i5 As Integer, i6 As Integerįor i = 65 To 66: For j = 65 To 66: For k = 65 To 66įor l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66įor i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66įor i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ĪctiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _Ĭhr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ or Sheet Name which you want to un-protect and then In the Above White Space Enter the below Code (In Italics). Press ALT + F11 or click on View Code in Developers TabsĬhoose the Sheet No. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps. In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet.

This document will tel you how to unprotect an excel spread sheet without having the password.

Sometimes we need to change the content of the file to suit our requirements but we will not be able to make the changes if the excel sheet is password protected. Sheets of which are password protected by the author of the file.

We many times receives excel files from various sources.

Itr offline utility