Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop calculation on workboook open
Greetings and TIA for your help.
I was hoping to do this with the code below but my workbook still recalculates when opening, if another workbook (already open) was set to automatic calculation. Please advise Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub -- David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop calculation on workboook open
David,
Did you put this code in the ThsiWorkbook code module? -- HTH RP (remove nothere from the email address if mailing direct) "David" wrote in message ... Greetings and TIA for your help. I was hoping to do this with the code below but my workbook still recalculates when opening, if another workbook (already open) was set to automatic calculation. Please advise Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub -- David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop calculation on workboook open
I think your workbook is open with the existing calculation setting before it
excel gets to your code. You could either change the setting manually, then open your workbook or create a dummy workbook that changes the setting, opens your workbook and closes itself. Then use that dummy workbook to open your workbook--don't open your workbook directly. Private Sub Workbook_Open() Application.Calculation = xlCalculationManual workbooks.open(filename:="C:\myworkbook.xls") thisworkbook.close savechanges:=true End Sub Save this once before you run it, or you'll have to type it in again! David wrote: Greetings and TIA for your help. I was hoping to do this with the code below but my workbook still recalculates when opening, if another workbook (already open) was set to automatic calculation. Please advise Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub -- David -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop a calculation in progress | Excel Discussion (Misc queries) | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
stop calculation | Excel Programming | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |