makako
10-03-2006, 07:08 AM
Recently I changed in my addin all calculations. I used to have tha option of calculate to automatic but loading data, etc. was taking too long o i decided to use calculation as manual. This way I use range(...).calculate and the loading data into a userform, etc. is way faster. The addin worked fine for a few days but suddenly Excel started to crash everytime i start call for the userform and asks me if i want to send the report or not. The problem is only when loading the userform and my most significant problem is that when running the code step by step works fine. Also i have tried to show in the status bar the "advance" of the code and apparently excel collapses just before the showing of the main userform after loading all data. Thanks. Any idea?