Here is my issue, and I've been having trouble nailing down exactly what the problem is, especially since it's an intermittent problem.

I'm (and everyone using the program) uses office 2010. This is a VBA project. I have a userform that initializes, and the first page that loads up is essentially a menu page. It has six buttons that take you to a specific page depending on the button pressed. The userform ALWAYS loads up in this state with no problems.I am not using any extra references other than what pre-loads when you create a macro.

Now, the error that comes up (and at this point, I'm not sure whether it's just a single button that is triggering it, or if the problem resides with all buttons) is when you press a button to go to a page, you get a runtime error. Once you click on either the debug option, (or any other option for that matter), excel then locks up, crashes and shuts itself down. The error I get reads "Runtime error '2147417848 (80010108) automation error. The object invoked has disconnected from the client."

Here is where the issue gets somewhat weird. By loading the program and pressing the first button, it always runs the same code. Yet, the crashing error is somewhat intermittent. Some users will report having the error, some won't. For some people, the crash happens every so often when they open up the sheet, and others it happens every single time they try and run it. The first time I noticed it was when I had just added Option Implicit to every module that I was using. I tried removing that, and the error seems to keep recurring. The intermittent nature of the bug (coupled with the fact that excel crashes out when i try to see what line it's crashing on) has made this a frustrating error to deal with.

I would post the excel file to try out, but I'm not sure if my employer would allow, as there's some proprietary information within the sheet with regards to pricing etc. I'm just trying to figure out what the actual error means so that I can try and have a good idea where to look for the problem.

Thanks!