melewie
Board Regular
- Joined
- Nov 21, 2008
- Messages
- 188
- Office Version
- 365
- Platform
- Windows
Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
I am having problems with returning a workbook to automatic calculation, I am using the below code<o
></o
>
<o
></o
>
<o
></o
>
<o
></o
>
I have stepped through the code and it is definitely reading the code but not changing the WB back to auto calculation. I am fully stuck with this and any help would be greatly appreciated.<o
></o
>




<o


I am having problems with returning a workbook to automatic calculation, I am using the below code<o


<o


Code:
[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]Application.Calculation = xlManual<o:p></o:p>[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]<o:p></o:p>[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]Lots of code<o:p></o:p>[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]<o:p></o:p>[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]Application.Calculation = xlCalculationAutomatic<o:p></o:p>[/FONT][/COLOR]


<o


I have stepped through the code and it is definitely reading the code but not changing the WB back to auto calculation. I am fully stuck with this and any help would be greatly appreciated.<o

