I have a gigantic excel file with multiple macros and 10+ tabs. I feel that the file has become corrupt. Excel will not let me save the file as a macro-enabled workbook but instead saves the file where I put it. When I go back to find it the icon for the file is a blank sheet of paper and then I have to specify that the file should be run in Excel. Why does this happen? It will not let me save the file as any other type of file (ie: 2003, 2007). When I go to "save as" the only file type it will let me save as is "Excel Files". It will also not always recognize the new macros that I have built, but still recognizes the old macros I built before the problem started to occur.

Any ideas as to what the problem is and what a solution might be?

Thanks in advance.