Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
manual calculate
Hi,
Is there any way to force a workbook to stay in manual calculate mode upon opening? I understand that the calculation mode is at the application level and not the workbook level and the workbook will change to auto calculate if another workbook is already open in auto calculate mode. Is there any way around this? Thanks, Adam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
manual calculate
Put this macro in the workbook code area:
Private Sub Workbook_Open() Application.Calculation = xlManual End Sub -- Gary''s Student - gsnu200778 "Adam" wrote: Hi, Is there any way to force a workbook to stay in manual calculate mode upon opening? I understand that the calculation mode is at the application level and not the workbook level and the workbook will change to auto calculate if another workbook is already open in auto calculate mode. Is there any way around this? Thanks, Adam |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
manual calculate
This is going to sound like a stupid question, but what do you mean by the
"workbook code area?" I tried inserting the visual basic code you suggested where all of my other macros are and it didn't work. Thanks, Adam "Gary''s Student" wrote: Put this macro in the workbook code area: Private Sub Workbook_Open() Application.Calculation = xlManual End Sub -- Gary''s Student - gsnu200778 "Adam" wrote: Hi, Is there any way to force a workbook to stay in manual calculate mode upon opening? I understand that the calculation mode is at the application level and not the workbook level and the workbook will change to auto calculate if another workbook is already open in auto calculate mode. Is there any way around this? Thanks, Adam |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
manual calculate
Nevermind. I figured it out. Thanks!
"Adam" wrote: This is going to sound like a stupid question, but what do you mean by the "workbook code area?" I tried inserting the visual basic code you suggested where all of my other macros are and it didn't work. Thanks, Adam "Gary''s Student" wrote: Put this macro in the workbook code area: Private Sub Workbook_Open() Application.Calculation = xlManual End Sub -- Gary''s Student - gsnu200778 "Adam" wrote: Hi, Is there any way to force a workbook to stay in manual calculate mode upon opening? I understand that the calculation mode is at the application level and not the workbook level and the workbook will change to auto calculate if another workbook is already open in auto calculate mode. Is there any way around this? Thanks, Adam |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
manual calculate
For a particular workbook I would use Event code.
Private Sub Workbook_Open() With Application .Calculation = xlAutomatic End With End Sub Right-click on the Excel Icon left of "File" and select "View Code". Copy/paste the above into that Thisworkbook module. Alt + q to return to the Excel window. Save the workbook. Gord Dibben MS Excel MVP On Fri, 11 Apr 2008 12:34:00 -0700, Adam wrote: Hi, Is there any way to force a workbook to stay in manual calculate mode upon opening? I understand that the calculation mode is at the application level and not the workbook level and the workbook will change to auto calculate if another workbook is already open in auto calculate mode. Is there any way around this? Thanks, Adam |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
manual calculate
Or you could use xlManual since that's what you asked for<g
Gord On Fri, 11 Apr 2008 15:31:02 -0700, Gord Dibben <gorddibbATshawDOTca wrote: For a particular workbook I would use Event code. Private Sub Workbook_Open() With Application .Calculation = xlAutomatic End With End Sub Right-click on the Excel Icon left of "File" and select "View Code". Copy/paste the above into that Thisworkbook module. Alt + q to return to the Excel window. Save the workbook. Gord Dibben MS Excel MVP On Fri, 11 Apr 2008 12:34:00 -0700, Adam wrote: Hi, Is there any way to force a workbook to stay in manual calculate mode upon opening? I understand that the calculation mode is at the application level and not the workbook level and the workbook will change to auto calculate if another workbook is already open in auto calculate mode. Is there any way around this? Thanks, Adam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual merge | Excel Discussion (Misc queries) | |||
My IF statement is stating False but if I manual calculate it it | Excel Discussion (Misc queries) | |||
Manual Transpose | Excel Worksheet Functions | |||
why would calculate change from automatic to manual on its own? | Excel Discussion (Misc queries) | |||
Manual Links | Links and Linking in Excel |