I'll pay 50$ to anyone that can state a solid code to overcome such situation.
It's best to quote the problem itself first
Please see for the explanation of the problem itself.
and also http://forums.microsoft.com/MS…x?PostID=1621009&SiteID=1 and likely other places
What I'm expecting from you is to find a solid solution to this and avoid excel crash while allowing a safe save with compiled VBA + granting that excel will not crash on next time reopened and ran the VB of the saved file.
Posting my specific code won't help because it's actually caused by this problem (very sure).
Hopefully I made myself clear.