Contributions
Re: Excel worksheet can not be edited
TanyaYatskovskawrote: Hibatilmoore, There is the only one official solution to get access to the Excel - get a password to unlock the file. All other approaches are considered asa hacker attack which we don't support. Do you need to use that file for reason? Could you please describe your use case in detail? Perhaps, we can suggest you an alternative solution. it is not open password so i can see view the content. However, no way to make any change. I tried the VBA code with this guide but no help:https://www.instructables.com/id/VBA-Code-To-Unlock-A-Locked-Excel-Sheet/ p.s it is now fixed with the help of this guide:https://www.androidphonesoft.com/resources/unprotect-excel-sheet-without-password.html2KViews0likes0CommentsRe: Excel worksheet can not be edited
tristaanogrewrote: Where did you download the test data from? Did they provide a password for you to access the spreadsheet? What code did you try? Keep in mind, using VBA for Excel is going to have some mixed results because the syntax and available objects aren't going to be there. It is from a personal website who writes posts about big data. I already asked the owner but no reply yet.2.2KViews0likes4Comments