I have an Add-in which works perfectly with Excel 2007 and 2003, however, when I switched to Excel 2010, "Userform_activate" sometimes is bypassed after using ".Show" to load a userform. The user form can be loaded without any problem, but any code in the Private Sub Userform_Activate() will not be executed. Has any one seen this before? Any help is appreciated.
Bookmarks