| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro freezes Excel
Hi all
I wrote some macros to interact and manipulate data in Access from Excel The macros works fine, but took quite a while to finish the calculation, around 2-3 minutes, and while performing the calculation, Excel freezes If running that macro only once in a while is no problem.. but it's starting to get irritating if everytime you run the macro, you need to wait for 3 minutes before you can get back to the Excel file again My question is Is there any way to tell Excel to run the macro in the background so that I can still work on my Excel file while Excel is doing the calculation Regards Yohan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
| Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running | Setting up and Configuration of Excel | |||
| Excel freezes | Excel Discussion (Misc queries) | |||
| Macro freezes spreadsheet | Excel Discussion (Misc queries) | |||
| Macro freezes after using Filters. | Excel Discussion (Misc queries) | |||
![Yohan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
