Could not access my macro

[adeina]

Dear all,
I could not open the macros that I just made in an Excel file. Is there a way to restore the macros? I still could open the Excel file (with disable macro function) but everytime I tried to enable the macros, it just got stuck and not responding. Any ideas about what is happening? I really hate to start all over again

Thanks in advance!

Adeina

[Excelenator]

Are your macros in the "Workbook_Open" event? If so it sounds like you are causing some sort of infinite loop or some other event that the macro doesn't end. You can open the workbook (without disabling macros) while holding down the shift key so that the workbook_open event won't occur and your macros will be available for debugging.

Good luck!