Sunday, July 04, 2010

Unlock a protected excel sheet

I had this excel sheet which was a RFP document and needed to copy a part of it as a response but this sheet was protected and selection was disabled on the sheet for the desired columns

Came across this amazing macro which would disable the password and make the columns selectable.

http://mcgimpsey.com/excel/downloads/allinternalpasswords.xls

basically when this excel sheet was opened a new addin button is created which could be used to unlock the sheets.