I have an excel sheet with forms and lot of VBA code. I modified some code, saved it and tested it ...it worked fine. I closed it and now when i try to reopen it. It gives me an error : Invalid Data. If i try to go in the particular Module where i made the changes it does'nt let me go in...with same error (though i can view all other modules and code. I also tried exporting it ...but again Mr. Invalid Error is on the gate and does'nt allow me to do anything.

I have a slightest idea that the template might have been corrupted, but no idea why...could anyone help me understand it(if possible). (I did not use any new variables

And any ideas.....what should i do(except redoing it).