| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When does the Workbook_Open event occur?
Hello all,
We have some large workbooks that can take quite a bit of time to calculate when they are opened, if they don't lock up Excel. The problem is if we have other unsaved workbooks open when we open one of these AND it crashes Excel, we lose the changes made to these other workbooks. I was wondering if the Workbook_Open event occurs before the sheet starts to calculate? If I put code in this event to turn off Automatic Calculation, will it keep Excel from calculating? -- Thanks for any help anyone can provide, Conan Kelly |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When does the Workbook_Open event occur?
Hi Conan
Look here http://www.cpearson.com/excel/events.htm Set calculation to manual in the large books and save them See also this site http://www.decisionmodels.com/optspeedd.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, We have some large workbooks that can take quite a bit of time to calculate when they are opened, if they don't lock up Excel. The problem is if we have other unsaved workbooks open when we open one of these AND it crashes Excel, we lose the changes made to these other workbooks. I was wondering if the Workbook_Open event occurs before the sheet starts to calculate? If I put code in this event to turn off Automatic Calculation, will it keep Excel from calculating? -- Thanks for any help anyone can provide, Conan Kelly |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When does the Workbook_Open event occur?
Ron,
Thanks for the help. That info looks pretty good. Conan "Ron de Bruin" wrote in message ... Hi Conan Look here http://www.cpearson.com/excel/events.htm Set calculation to manual in the large books and save them See also this site http://www.decisionmodels.com/optspeedd.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, We have some large workbooks that can take quite a bit of time to calculate when they are opened, if they don't lock up Excel. The problem is if we have other unsaved workbooks open when we open one of these AND it crashes Excel, we lose the changes made to these other workbooks. I was wondering if the Workbook_Open event occurs before the sheet starts to calculate? If I put code in this event to turn off Automatic Calculation, will it keep Excel from calculating? -- Thanks for any help anyone can provide, Conan Kelly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook_Open() Event | Excel Discussion (Misc queries) | |||
| VBA problem - prevent event to occur when certain button is clicked | Excel Programming | |||
| Workbook_open Event | Excel Programming | |||
| WorkBook_Open Event | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Linear Mode
