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.
which runs
Please help!
Many Thanks
Bookmarks