Hi,

Excel crashes when I press a button which runs a macro userform1.show OR when I use auto_open.

If I go into the vba code and run it line by line, the program works fine.

Once excel has crashed and windows recovers the file, I then get an "Automation Error" box pop up asking me to close the application.

I am using Excel 2013 on one computer and Excel 2010 on another, the issue happens on both.

Part of my code is pasted below - Please let me know if you need the full code to help identify the issue.

Please Login or Register  to view this content.
which runs

Please Login or Register  to view this content.
Please help!

Many Thanks