Hi I am new to this forum and was hoping someone may be able to help me with this problem.
I am using macros in my Excel 2007 files and recently got a new computer with Windows 7 64-bit Professional on it. I wanted to add more functionality to my workbook but there was some problem with the code.
When I hit 'Debug' it went to the code in VBA and 10 seconds later Windows was busy closing Excel - "Excel has stopped working". This happens every time no matter what I do!

I don't think this has to do with faulty Office products but the fact that Windows 7 sees Excel as non-responsive although I think it is only paused while I am stepping though the code!
Any ideas?