How to remove protection in workbook/worksheet!

Hello Excelhackers,

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.

password remover macro for EXCEL protected workbook


  1. Opening VBA (ALT +F11)
  2. Paste the code at above link in Module 1.
  3. Close the VBA.
  4. Go to View —->Macros—->View Macros—->select “AllInternalPasswords”—->Press Run
  5. Follow the dialogue box that appear and the protection will be removed from the file.

Yo you are good to go.

CA Dhaval Paun




Subscribe for Newsletter