ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel 2002 crashes (https://www.excelbanter.com/new-users-excel/13359-excel-2002-crashes.html)

Veena

Excel 2002 crashes
 
Hi,
When i try to add a control to a from in Excel VBA using the
function OLEObjects.Add, Excel 2002 crashes.
Well, i have found the solution to the problem which is that before
adding the control I set the EnableEvents property to false. Then
everything works fine.
The reason for my post is that, this same problem does not happen in
Excel 2000, it happens only in Excel 2002..

Any idea why this is so ?

Please help!!!
Thanks & Regards,
Veena.


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com