Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
24
Views
Topic starter
i want to remove the password when i am entering the excel sheet then asking me password how should i solve this problem i want solution why because i forget many time password
Posted : 28/09/2019 1:03 am
You can open the excel file with 7Zip, or winRar, or any other archiver, then go to xl folder->worksheets. In worksheets folder, you will see multiple xml files, locate the one you want, open it and remove this line:
<sheetProtection password="CA49" sheet="1" objects="1" scenarios="1"/>
It might look slightly different on your side.
Posted : 28/09/2019 1:53 am