Hi an excel question.
I have an *.xlsm file which i forgoten password to. I made it years ago, stopped using it, but now i need it again - urgent.
1) The file itself is not locked with general password for opening (i can open the file but inside i can not change anything - read only)
2) All the spreadsheets are locked
3) The structure of file is locked
Since the file structure is locked I cannot use VBA method to unlock it.. since I cant access developer..
I also tried uploading original *.xlsm file to google docs and downloading it as *.xlsx - this however did remove password protection but it also disabled all the macros. I tried saving it back to macro enabled format (*.xlsm) but macros do not work anymore.
I need to unlock the sheets and macros need to remain working.
Please help if any of you guys know how to unlock it. Its very imporant for my job. Thank you for any positive answers on this issue.
I have an *.xlsm file which i forgoten password to. I made it years ago, stopped using it, but now i need it again - urgent.
1) The file itself is not locked with general password for opening (i can open the file but inside i can not change anything - read only)
2) All the spreadsheets are locked
3) The structure of file is locked
Since the file structure is locked I cannot use VBA method to unlock it.. since I cant access developer..
I also tried uploading original *.xlsm file to google docs and downloading it as *.xlsx - this however did remove password protection but it also disabled all the macros. I tried saving it back to macro enabled format (*.xlsm) but macros do not work anymore.
I need to unlock the sheets and macros need to remain working.
Please help if any of you guys know how to unlock it. Its very imporant for my job. Thank you for any positive answers on this issue.