![]() 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 |