Results 1 to 2 of 2
2003-03-04, 19:06 #1
- Join Date
- Nov 2002
- Thanked 0 Times in 0 Posts
workbook formulas processed before open event (excel 2000/r2)
I have a Excel workbook where I load xla's in the Thisworkbook object of the template. I have noticed that if the workbook has formulas then a "pre-calculation" is processed before the workbook open event. Is there someway to not have this occur?
2003-03-04, 23:24 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Re: workbook formulas processed before open event (excel 2000/r2)
<img src=/S/hello.gif border=0 alt=hello width=25 height=29> Jim
Could you open <font color=red>"Another"</font color=red> workbook that would turn calculations to manual, (<font color=blue> Application.Calculation = xlManual </font color=blue>) then open your template, your add-Ins and the last add-In closes the <font color=red>"First"</font color=red> workbook and set calculations to Automatic, or what ever you care it to be from that point on?
Seems like a lot of work, and I am searching for an example of what event fires when, and in what sequence, but I am sure that the Workbook.Open is one of the <font color=red>"VERY Early"</font color=red> ones.
I hope this helps.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>