Hi,
I've got a problem when opening the excel. I've been searching around this problem, however, it's not exactly what I'm encounter.
I have an excel 2007 file which contain a lot of macros. File size is 100MB. This file is not developed by myself, it's post in the webpage and let the members of the page to download on daily basis..
I've been downloading and using this file for over a year with no problem until this week.

Problem:
During opening the file. There is a message box popped up, saying "Excel found unreadable content in filename.xlsm'. do you want to recover the contents of this workbook ? If you trust the source of this workbook, click Yes." When I click "yes", excel is trying to repair the file. Once it's done, I could see only the contents, however, all the macros are gone. When I copied this very same file and open in other notebooks, everything is working fine...

Assumption:
Couple days ago, I was writing/testing macros in other workbooks and also opened this particular file. I might did something stupid which cause this problem...
During the same time, I used to have the same problem with another file. I solved it by copy and open with another PC then copy macros and paste it to the file on my notebook. I could not apply the same fix with the current problematic file as there are tons of macros.

Could anyone help me on this problem ??
Thank you for your help in advance...
Cedia2545..