How to remove protection in workbook/worksheet!
Many a times you receive a protected file and you desperately want to un-protect it to view the hidden cells and formulas etc.
This is very simple with the help of running below macro.
- Opening VBA (ALT +F11)
- Paste the code at above link in Module 1.
- Close the VBA.
- Go to View —->Macros—->View Macros—->select “AllInternalPasswords”—->Press Run
- Follow the dialogue box that appear and the protection will be removed from the file.
Yo you are good to go.
CA Dhaval Paun