Sorry I haven't tested it as I don't have access to an ancient version of Excel at present and don't run a Virtual Machine. But they really need installing on a computer without any later versions of Excel on it or using a Virtual machine approach. ![]() Old versions of Excel are still available on Ebay etc. The disadvantage is that you lose all features from later versions of Excel but you will generally, at least, have back access to all your data and that, indeed, might well be your lifesaver. That code will find a password that opens any number of hidden sheets or protected structure. McGimpsey & Associates : Excel : Remove internal XL passwords You can also copy the allinternalpasswords VBA code I wrote in 2002 from: Press Alt + F11 to open the Visual Basic Editor. (it should be active when you run the code). You can do it by clicking on the file icon, it will open a list of options, select the info tab and click on the protect workbook. I wrote an explanatory document on including the code used this in Word and I attach that for your assistance. Open your Excel document and switch to the password-protected sheet. I think it might work with a bit of a 'glitch' on 2013. That file can run on later versions of Excel but doesn't work on Excel 365, or Excel 2019, or 2016. Open also the file I attach to this post. Open your file on the computer running the old version of Excel. You then need access to a computer running a version of Excel before Excel 2016 and preferably as early as 2007. That operation in your new workbook will have lost all features used by Excel versions after Excel 2003. Save the workbook under a new name but use Save as Type "Excel 97-2003" The time it will take depends to a large extent on the power of the approach still works although I haven't tested it recently. 'CAUTION!! Recommended only for proprietary Excel sheets! Option Explicitĭim i#, j#, k#, l#, m#, n#, o#, p#, q#, r#, s#, t# In a common Module we paste the following code that removes the code from the activated sheet: ![]() If it is a matter of removing (not retrieving) a Worksheet password, the following code may be used: For some worksheets it can take a whole day, sometimes more.īut in the end, I was able to decipher all worksheets 99% of the time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |