I'm hoping someone can help me out. I've utilized a macro which forces a user to enable macros on a worksheet and what happens is when this form is open and at least one other document is open, Excel crashes upon closing (not saving).
Luckily there's auto recover, but that's not a solution when about 10 people use this form so I've narrowed it down to opening the file within a single instance of Excel in addition to one or more other documents.

I've been able to solve this by opening Excel in another instance (another process is created by default), but this requires a registry change as I haven't successfully gotten Excel to do this through its own settings.

The macro I have is activated when someone saves, opens, and closes the document so I'm sure it lies within here, but I can't tell if there's some condition or loop that's causing Excel to overload or not.

Please Login or Register  to view this content.
Thanks for any help!