| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do Excel define the application area?
When I run a macro as shown below, how does excel define the application
area? Disable re-calculation option before processing coding After processing coding, enable re-calculation option calcmode = application.calculation application.calculation = xlCalculationManual 'open worksheet2.xls by using worksheet1's macro application.calculation = calcmode Case 1 If I open an excel worksheet1.xls, then I open worksheet2.xls within this open worksheet1, do I open 1 excel application? If I set calcmode, will it apply to both worksheets at this moment? Case 2 If I open an excel worksheet1.xls, then I open another excel application and open worksheet2.xls, do I open 2 excel application? If I set calcmode for worksheet2, will it apply to worksheet1.xls at this moment? Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define Print Area using Variables | Excel Programming | |||
| define a print area and name it based on info in first cell in a row... | Excel Programming | |||
| Application-Defined or Object Define error? Help please. | Excel Programming | |||
| Help recording a macro to define print area | Excel Programming | |||
| Highlighting a Block of Cells to Define the Print Area | Excel Programming | |||
Threaded Mode
