Hi Luke thanks,Run this macro:
http://www.mcgimpsey.com/excel/removepwords.html
Yes I tried but Negative result.Maybe like this, first open new excel document and enter the code, after that open your password protected excel file from inside new excel document.